Discussion Board for collaboration on QlikView Layout & Visualizations.
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:
along with JobraisedDate
Please help me as iam new to Qlikview
Thanks in advance.
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,
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.