Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
ssriramin19
Contributor III
Contributor III

syntax for set analysis

My expression for actual sales

if(u1='1' or u2 <>'1',(Sum({<Year={$(=Max(Year))}>}actual_Sales*[ME Curr Factor Actual]))

)

The above expression works fine .But the requirement is that there is a field called LAG . When LAG field is clicked the actual sales values should not change. But it is currently changing.Both actual_sales and LAG are fetched from the same table.

I know sum({<[LAG]=>} will work. This will make selections independent. But how do I need to incorporate this expression sum({<[LAG]=>} in the above actual_sales expression .


Please provide the needful on this

Thanks

Sriram

1 Solution

Accepted Solutions
pokassov
Specialist
Specialist

if(u1='1' or u2 <>'1',(Sum({<[LAG]=,Year={$(=Max(Year))}>}actual_Sales*[ME Curr Factor Actual]))

)

View solution in original post

4 Replies
pokassov
Specialist
Specialist

if(u1='1' or u2 <>'1',(Sum({<[LAG]=,Year={$(=Max(Year))}>}actual_Sales*[ME Curr Factor Actual]))

)

View solution in original post

Not applicable

Use this one,

if(u1='1' or u2 <>'1',(Sum({<Year={$(=Max(Year))}, LAG = >}actual_Sales*[ME Curr Factor Actual]))

)

ssriramin19
Contributor III
Contributor III
Author

Thanks very much for expression provided. It works as needed.

ssriramin19
Contributor III
Contributor III
Author

Thanks Sergey for the expression.it works as needed.