topic Help with Set Analysis in QlikView

Help with Set Analysis

DSTaylor — Thu, 13 Feb 2020 11:27:44 GMT

Hi,

I have a quick question that will hopefully save a lot of time if there is a resolution.

I'm currently building a chart showing monthly data that is cumulative i.e. February = January + February.

Currently I have:

if(ReportMonth='Jan',

sum({$<ReportMonth={'Jan'}>} Value),

if(ReportMonth='Feb',

sum({$<ReportMonth={'Jan'}>} Value),

sum({$<ReportMonth={'Feb'}>} Value),

As you can imagine this will quickly build up into a huge piece of script by the time December is reached (This is not the only line but can be used as an example individually for the script required).

Is it possible to get something along the lines of:

if(ReportMonth='Feb',

sum({$<ReportMonth={'Jan'+'Feb'}>} Value)

Any help would be massively appreciated

Re: Help with Set Analysis

agigliotti — Thu, 13 Feb 2020 11:33:35 GMT

what about this:

rangesum( above( sum(Value), RowNo(TOTAL) ) )

I hope it helps.

Re: Help with Set Analysis

alex00321 — Thu, 13 Feb 2020 11:55:35 GMT

Hi will

if(ReportMonth='Feb',

sum({$<ReportMonth={'Jan','Feb'}>} Value)

work? Thanks!

Re: Help with Set Analysis

sunny_talwar — Thu, 13 Feb 2020 11:59:47 GMT

Check out The As-Of Table

Re: Help with Set Analysis

Brett_Bleess — Wed, 11 Mar 2020 15:04:03 GMT

You have quite a few replies, just wanted to be sure you circle back to your post and if any did help, please be sure to close out the thread by using the Accept as Solution button on the post(s) that were helpful in solving your issue. If you are still working on things, please leave an update on what you still need.

Regards,
Brett