topic Re: syntax for set analysis in QlikView

syntax for set analysis

ssriramin19 — Mon, 24 Aug 2015 07:29:13 GMT

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

Re: syntax for set analysis

pokassov — Mon, 24 Aug 2015 07:35:13 GMT

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

)

Re: syntax for set analysis

Mon, 24 Aug 2015 07:39:31 GMT

Use this one,

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

)

Re: syntax for set analysis

ssriramin19 — Mon, 24 Aug 2015 07:43:03 GMT

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

Re: syntax for set analysis

ssriramin19 — Mon, 24 Aug 2015 07:57:19 GMT

Thanks Sergey for the expression.it works as needed.