Discussion board where members can get started with Qlik Sense.
I am using the below expression directly in a chart its working but if I try to create a variable using the same expression its giving the expected result. Could any one help me?
Thank you in advance.
Rekha J. V.
Go to Solution.
try to call it as follow :
can u please develop more?
1) what chart u're using this expression in? which dimension?
a screen shot maybe?
2) when u use a variable? how are u using it?
how are u calling it?
screen shot maybe?
This is how I am using in KPI
Created a variable using same:
Now if I use the variable in KPI it will not show up the date
Nor its showing when I use in Set expression
How you define in variable?
LET Variable = =Date(max(Close_Week_End_Date),'YYYY-MM-DD');
='$(vCurrentWeekEndDate)' returns the appropriate date.
Good, but u should have marked my answer as correct
Sorry by mistake. Marked your answer as correct. :-)
Thanks once again.