Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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

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

)

View solution in original post

Highlighted
Not applicable

Use this one,

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

)

Highlighted
Contributor II
Contributor II

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

Highlighted
Contributor II
Contributor II

Thanks Sergey for the expression.it works as needed.