Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
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)')
Rgds,
Jim
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.