topic Re: set analysis expression in QlikView

set analysis expression

ssriramin19 — Wed, 26 Aug 2015 11:56:45 GMT

I have the expression in my table

SUM(OP_actual)-SUM(([PSGL Sales Amt]))

I need to include sum({<LAG_DP]=>} in the above expression . To make the LAG_DP independent of selections for MRE the set analysis needs to be included in the above sum expression

Can anyone tell me how to include set analysis (LAG_DP) in the above sum expression?

Please do the needful on this .

Thanks

Sriram

Re: set analysis expression

kaushiknsolanki — Wed, 26 Aug 2015 12:03:00 GMT

Hi,

Try this.

SUM({<LAG_DP=>}OP_actual)-SUM(({<LAG_DP=>}[PSGL Sales Amt]))

Regards,

Kaushik Solanki

Re: set analysis expression

qlikmsg4u — Wed, 26 Aug 2015 12:05:54 GMT

if you want to make LAG_DP independent of selections then do this way

Sum({<LAG_DP=>}OP_actual) - Sum(({<LAG_DP=>}[PSGL Sales Amt]))

Re: set analysis expression

ssriramin19 — Wed, 26 Aug 2015 13:18:18 GMT

Thanks very much on helping me on this.