Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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

Tags (1)
1 Solution

Accepted Solutions
abhaysingh
Contributor III

Re: How to implement Expression from QView to QSense

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

6 Replies

Re: How to implement Expression from QView to QSense

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

Re: How to implement Expression from QView to QSense

Hi Gysbert,

could you teach me how to define variable in qvf?

Re: How to implement Expression from QView to QSense

You use the LET or SET keywords:

SET vMyVariable =1;

LET vMyTime = now(1);


talk is cheap, supply exceeds demand
abhaysingh
Contributor III

Re: How to implement Expression from QView to QSense

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
Contributor III

Re: How to implement Expression from QView to QSense

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

Not applicable

Re: How to implement Expression from QView to QSense

Hi Abay,

Thank you, it is work.

Regards,

Ted

Community Browser