If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Chart Series-URGENT

Started by Sep2013, 25 Feb 2013 01:26:09 AM

Previous topic - Next topic

Sep2013

Hi Frends,

I have created a chart in cognos express.
The user wantes to hide the zero values,meaning that actual's line should finish at 201307 and should not be shown after this.
PFA the output and advise if i can do that

adik

put a filter in your query on Ledger dollars > 0

Sep2013

the problem is value of actual is non zero till 201312, but user wants to see the value to productivity till 201312 and value of actual till 201307(that is till last month0
For this i have used a calculation as follows:
IF
(caption (children([Selected Year])) < caption (firstChild ([This Month])))
THEN
([Actual])
ELSE
(null)

and the query uses slicer functions instead of filters as its cube data.
:( Any other way of doing it?

adik

filters and slicers are two different things, you can have both filters and slicers
my idea would be to create two queries, one for each measure and for the Ledger dollars query put a filter of > 0
then create a third query as the union of the two