Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

archana_g
New Contributor II

calculated dimension showing all values in current selection

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.

2 Replies
cesaraccardi
Valued Contributor

Re: calculated dimension showing all values in current selection

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

sksingh3286
New Contributor II

Re: calculated dimension showing all values in current selection

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

Community Browser