Discussion board where members can get started with Qlik Sense.
i am converting a chart from qlikview to qlik sense - but the below code, doesnt seem to work in Qlik Sense, but is 100% work in qlikview. what are the syntax error you think?
= IF(DR_DTLS_MONTHNAME = 'Jan','Month Actual $(vPriorMonth) $(vPriorYear)','Month Actual $(vPriorMonth) $(vMaxYear)')
Do you already have the variables created in Qlik Sense? -> $(vPriorMonth) $(vPriorYear) and $(vPriorMonth) $(vMaxYear)
yes created. i wanted to put this expression in label.
Your syntax is OK, so the problem must be to do with the variables.
ok. let me check again
try displaying the variables as a measure in a KPI visualisation object to see what's happening. It helped me when debugging variable content.