Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
archana_g
Partner - Contributor III
Partner - Contributor III

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

Anonymous
Not applicable

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