Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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