How to implement Expression from QView to QSense

[#1]

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

[Gysbert_Wassenaar]

In your expressions you use three variables. You have to define those variables in the script in Qlik Sense.

[#3]

Hi Gysbert,

could you teach me how to define variable in qvf?

[Gysbert_Wassenaar]

You use the LET or SET keywords:

SET vMyVariable =1;

LET vMyTime = now(1);

[abhaysingh]

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

[abhaysingh · Accepted solution]

try like this  Sum({< Year ={'$(=max(Year))'}>}Sales)

[#7]

Hi Abay,

Thank you, it is work.

Regards,

Ted