calculated dimension showing all values in current selection

[archana_g]

hi

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]

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]

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