set analysis expression

[ssriramin19]

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

[kaushiknsolanki · Accepted solution]

Hi,

Try this.

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

Regards,

Kaushik Solanki

[qlikmsg4u]

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]))

[ssriramin19]

Thanks very much on helping me on this.