Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. 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.