topic Re: Incremental Month Count From First Month in QlikView

Incremental Month Count From First Month

MalcolmCICWF — Sat, 16 Nov 2024 18:01:51 GMT

I have yet to be able to find a solution to this out there. I am trying to create a pivot table of incremental months starting at the first month. There is a record for each month the Example1 has existed... But, Example2 could start at a different month depending on when it was purchased. I want to, for each Example, have the initial month be 1, but continue to count each month that the Example exists.

In my Example1, it has existed for 16 months... but Example2 may have existed for 34 months... I am trying to figure out in the script how to create a field and label each month EACH example has existed. This point behind this is to show how much revenue has been brought in each month, not by actual MM/DD/YYYY, but by total months it has existed.

Re: Incremental Month Count From First Month

Kushal_Chawda — Wed, 30 Sep 2020 22:27:51 GMT

@MalcolmCICWF Assuming that you have example & month field available in data you can try below

LOAD *

.......

AutoNumber(Month,Example) as Number

resident Table

order by Example, Month;

drop table Table;

Re: Incremental Month Count From First Month

MalcolmCICWF — Thu, 01 Oct 2020 15:05:43 GMT

That simple huh? Never used that before, let me give it a shot and I'll report back

Re: Incremental Month Count From First Month

MalcolmCICWF — Tue, 27 Oct 2020 19:02:23 GMT

It indeed did work perfect for what I needed it for. thank you