topic Re: Cumulative Expression in QlikView

Cumulative Expression

Wed, 15 Aug 2012 18:15:02 GMT

Hello,

I would like to create a Cumulative expression, let's call it "Cumulative This Year".

On my Sheet, I have a list box titled "Month", that list the 12 months of the year.

Instead of my field "Cumulative This Year" adding all of the data for for the current year, I want it to stop at the month selected in the List box.

If June is selected as the Month, "Cumulative This Year" will consist data from January - June.

I have the follwing in my expression. Is there a way to adjust the ''Month" based on the value selected in the List box?

Sum({<DepletionYear= {"12"},Month = {"01","02","03","04"}>} Depletion)

Thanks in advance for your assistance,

Stephanie Smith

manojkvrajan — Wed, 15 Aug 2012 18:35:11 GMT

Stephanie, Should the application take the max month on selecting multiple months in the list box?

For example, on selecting May, October and November, should it take January through November? Please confirm.

Tue, 21 Aug 2012 12:26:14 GMT

Yes, that is exactly what I am looking for

daveamz — Tue, 21 Aug 2012 12:32:17 GMT

Hi Stephanie,

Set a variable vMonth = Month

then:

Sum({<DepletionYear= {"12"},Month = {"<=$(vMonth)"}>} Depletion)

Regards,

David

Tue, 21 Aug 2012 12:42:21 GMT

Hello David,

That sounds like it will work. But how to do a set a variable? Do I put it in my Expression script?

Thanks,

Stephanie

daveamz — Tue, 21 Aug 2012 12:56:21 GMT

Settings > Variable Overview (Ctrl+Alt+V) > Add > vMonth for variable name, =Month for Definition. Equal sign is mandatory.