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.
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
try to call it as follow :
='$(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.
How you define in variable?
LET Variable = =Date(max(Close_Week_End_Date),'YYYY-MM-DD');
Retrieving data ...