Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I have QVW document, and i wanna implement in Qsense,
but if i use expression in qvw doc, it cannot running in Qsense.'
this is the expression in qvw doc:
==> sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(sales)/$(1)/1000)
Hope someone help me,
Best regards,
ted
try like this Sum({< Year ={'$(=max(Year))'}>}Sales)
In your expressions you use three variables. You have to define those variables in the script in Qlik Sense.
Hi Gysbert,
could you teach me how to define variable in qvf?
You use the LET or SET keywords:
SET vMyVariable =1;
LET vMyTime = now(1);
Hi Gysbert..
in this expression i think ted is using exp directly not variable
sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(sales)/$(1)/1000)
Sum({< Year ={'$(=max(Year))'}>}Sales)
Thanks
Abhay
try like this Sum({< Year ={'$(=max(Year))'}>}Sales)
Hi Abay,
Thank you, it is work.
Regards,
Ted