Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED: Not Solved] Displaying negative values in () in Graph

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED: Not Solved] Displaying negative values in () in Graph
 Login/Join
 
DW Marker
Silver Member
posted
All,

I've searched and haven't been able to find a way to handle a user request for a graph. This graph will show % Changes versus a prior period, and therefore can have negative values. What the user wants is for the negative values to be displayed as (9.9%), as opposed to -9.9%. Can that be done? I am using standard graphs at this point.

This message has been edited. Last edited by: DW Marker,


WF 7.6.4
Windows XP and UNIX
 
Posts: 41 | Registered: November 26, 2008Report This Post
Waz
Expert
posted Hide Post
What values are you trying to get to (9.9), the axis, tooltip, or something else ?

DEFINE FILE CAR
 PCTVAL/D6.2B = DECODE COUNTRY('ENGLAND' 5.5 'ITALY' -9.9 ELSE 0) ;
END
GRAPH FILE CAR
SUM PCTVAL
BY COUNTRY
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRAPHEDIT OFF
ON GRAPH SET GRAPHSTYLE *
setDataTextDisplay (true);
setTextFormatPreset(getSeries(0),-1);
setTextFormatPattern(getSeries(0),"#0.00'%';(#0.00'%)'");
setTextFormatPreset (getY1Label(), -1);
setTextFormatPattern (getY1Label(),"#0.00'%';(#0.00'%)'");
ENDSTYLE
END

This message has been edited. Last edited by: Waz,


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
DW Marker
Silver Member
posted Hide Post
Okay, I can do the () around negative values, which I was doing for the Axis label and the data itself, which I had just about figured out when you posted. Now the question is can it be made red when it is negative? Since they want the numbers to appear a different color, not the bar?


WF 7.6.4
Windows XP and UNIX
 
Posts: 41 | Registered: November 26, 2008Report This Post
Waz
Expert
posted Hide Post
I can't seem to find an answer to this that is simple. you may be able to do this with a dual axis bipolar graph, but I think it will be difficult.

Hope someone else has a better suggestion.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
<JG>
posted
In theory you should simply be able to set the fill color using the following API calls
which you would have to pregenerate and -INCLUDE

setFillColor(getDataText(2), new Color(255,0,0));

However It does not work in 7.6.7 or 7.6.8.

You may be lucky and it might work in 7.6.4.

It seems to me that they have broken a lot of API calls recently

This message has been edited. Last edited by: <JG>,
 
Report This Post
DW Marker
Silver Member
posted Hide Post
Can I ask when you say I would have pregenerate and include that API call, is there a reason I'd have to do it that way, as opposed to just putting it in directly?

But either way we may end up opening a case on this as the user seems to really want this in there... Even changing the bar color doesn't make them totally happy. Darn end users!


WF 7.6.4
Windows XP and UNIX
 
Posts: 41 | Registered: November 26, 2008Report This Post
<JG>
posted
DW Marker

There are a number of examples on the forum about generating API calls and including them.

Basically you do a table request, hold the output, then do a -INCLUDE.

However the basic issue here is that the API calls do not work as documented.

That means you will need to raise a case with IBI and unfortunately may have to raise an NFR
which can mean a wait of several years if the ever deliver.

I think the user is going to disappointed on this one.
 
Report This Post
DW Marker
Silver Member
posted Hide Post
We are going to proceed with opening a case, and most likely an NFR also. Thanks for your input JG, it is much appreciated.


WF 7.6.4
Windows XP and UNIX
 
Posts: 41 | Registered: November 26, 2008Report This Post
Waz
Expert
posted Hide Post
Good luck with the case and NFR.

As a point of reference, the graph functionality comes from http://www.threedgraphics.com/...va/documentation.php, they have online manuals, and describe everything. IBI have put a wrapper around the java app, and exposed most methods and properties.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

 
Posts: 6347 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED: Not Solved] Displaying negative values in () in Graph

Copyright © 1996-2020 Information Builders