Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to implement Expression from QView to QSense

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.' ask set.png

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

1 Solution

Accepted Solutions
abhaysingh
Specialist II
Specialist II

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

View solution in original post

6 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
Not applicable
Author

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);


talk is cheap, supply exceeds demand
abhaysingh
Specialist II
Specialist II

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
Specialist II
Specialist II

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

Not applicable
Author

Hi Abay,

Thank you, it is work.

Regards,

Ted