Expression?

khadeer — Tue, 05 Feb 2013 12:13:53 GMT

Hi Below expression i declared in variable

sum({$<Month={$(=min(Month))},BA={'XXX'}>}POB)+(RangeSum(sum({<Month={$(=max(Month))},BA={'XXX'}>}Values))

+sum({$<Month={$(=min(Month))},BA={'XXX'}>}POB)

Its working fine for month selection, Year selection n Quarter selection.

But now i got new requirement that i have to show MTD of that variable.

I mean suppose my above expression giving values like

Apr= 200, May= 300, June= 400, July= 100

When i am selecting multiple selections also i am getting correct values means

Apr&May my result is correct= 500,

but my requirement is if selected May i want to show Apr+May instead of selecting both.

Thanks in advance.

topic Expression? in QlikView