Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
archana_g
Partner
Partner

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
Specialist
Specialist

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
Contributor II
Contributor II

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