topic Re: calculated dimension showing all values in current selection in QlikView

calculated dimension showing all values in current selection

archana_g — Thu, 09 Aug 2012 12:24:45 GMT

i have a graph in which i have used calculated dimension.

the condition is:

if(exception='-1',code='a' or code='b',JobraisedDate)

the value displayed should be jobraisedDate and its displayed in graph but

when iam selecting the graph then the current selection box displaying:

exception=-1

code=a

code=b

along with JobraisedDate

Please help me as iam new to Qlikview

Thanks in advance.

cesaraccardi — Thu, 09 Aug 2012 12:43:42 GMT

Hi,

I think your expression is wrong, the syntax for the "if" is:

if(condition,value for true, value for false)

You can't put code='a' or code='b' for the true, it must be only one returned value like: if(exception='-1','a',JobraisedDate).

Hope it helps,

Cesar

Anonymous — Thu, 09 Aug 2012 14:11:02 GMT

Hi Archana

Please provide a small sample of your data and what exactly you are trying to achieve.

Cesar is right in that your syntax for IF statement is incorrect.

Regards

Sid