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

Qlik sense scripting syntax error

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

5 Replies
sunny_talwar

Do you already have the variables created in Qlik Sense? -> $(vPriorMonth) $(vPriorYear) and $(vPriorMonth) $(vMaxYear)

jim_chan
Specialist
Specialist
Author

yes created. i wanted to put this expression in label.

jonathandienst
Partner - Champion III
Partner - Champion III

Your syntax is OK, so the problem must be to do with the variables.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
jim_chan
Specialist
Specialist
Author

ok. let me check again

ogster1974
Partner - Master II
Partner - Master II

try displaying the variables as a measure in a KPI visualisation object to see what's happening.  It helped me when debugging variable content.