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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Variable not working

Hi all,

I have a variable (vLastInsDtWeek) with this expression:

if(weekday(max(OrdItemInsDt))='sex',max({<OrdItemInsDt={*},OrdItemInsDtYear={'$(=vCurrentInsDtYear)'}>}OrdItemInsDtWeek), max({<OrdItemInsDt={*},OrdItemInsDtYear={'$(=vCurrentInsDtYear)'}>}OrdItemInsDtWeek)-1)

The expression works fine alone, in a text and image box and when I insert it "directely" in another expression. But, in this other expression, when I try ti use the variable name, OrdItemInsDtWeek={'$(=vLastInsDtWeek)'}, it doesn't work!

Do you have any idea what I might be doing wrong?

Thank you!

0 Replies