topic Re: addmonths and set analysis in QlikView

addmonths and set analysis

Mon, 25 Mar 2013 12:39:59 GMT

Hi guys,

I am stuck on something and since I'm new to set analysis I dont know how to procced. I have the following expression:

Sum({<Month = {"$(=month(addmonths(Max(Date),-1)))"},Year=,Date=>}Sales)

The expression basically SUMS the previous months "Sales". This works perfectly but when I only have a years data. But when I have sales for more than a year (i.e there are multiple Feb (2012 &2013) it sums the sales for both years. I just want the previous months sales.

Any ideas?

Regarss

Re: addmonths and set analysis

Gysbert_Wassenaar — Mon, 25 Mar 2013 12:42:38 GMT

Try:

Sum({<Month = {"$(=month(addmonths(Max(Date),-1)))"},Year={'$(=Year(addmonths(Max(Date),-1)))'} ,Date=>}Sales)

Re: addmonths and set analysis

Mon, 25 Mar 2013 12:57:30 GMT

Thanks man,

Works like a charm.

How can i work on my set analysis? I know practice. But do you know of any material or forums other than this one?

Re: addmonths and set analysis

kaushiknsolanki — Mon, 25 Mar 2013 13:03:45 GMT

Hi,

Have a look at the attached exmaple.

Hope this will clear your doubt.

Regards,

Kaushik Solanki