topic Set Analysis in QlikView

Set Analysis

rathnam_qv — Tue, 09 Jul 2013 06:37:05 GMT

Hi all,

i have the following Expression by using this i am getting current month data, but i need to get all months data.

=sum({<[Reporting Month ID]={'$(=max([Reporting Month ID]))'},Scenario={'Actual'}>}Balance

)/1000000

can any one help me...

Thanks in advance

smiley

Re: Set Analysis

Gysbert_Wassenaar — Tue, 09 Jul 2013 06:39:33 GMT

Try =sum({<[Reporting Month ID]=,Scenario={'Actual'}>}Balance)/1000000. This will disregard any selections in Reporting Month ID so the sum is calculated over all months

Re: Set Analysis

nirav_bhimani — Tue, 09 Jul 2013 06:42:06 GMT

Hi,

Remove the Reporting month condition,

=sum({<Scenario={'Actual'}>}Balance)/1000000

Regards,

Nirav Bhimani