topic Calculate a Number between two Months in QlikView

Calculate a Number between two Months

xyz2 — Thu, 30 Jun 2022 10:26:52 GMT

Hi,

I am new to Qlik and hope someone can help me with my problem.

Currently, i am counting the number of State with the status 'New':

=Count({<State={'New'}>}State)

But now, i am trying to display all the new added States for each month.

E.g.

Month	=Count({<State={'New'}>}State)	Added States
2022-January	100	100
2022-February	110	10
2022-March	120	20
2022-May	130	30
2022-June	140	40

Unfortunately i have no idea, how i can present "Added States" in Qlik.

I hope some of you have any idea and can help me out.

Thanks in advance!

Re: Calculate a Number between two Months

Or — Thu, 30 Jun 2022 10:30:30 GMT

Originally, I would have said perhaps Count({<State={'New'}>}State) - alt(Above(Count({<State={'New'}>}State)),0) as this would give the actual number of added states for each month, but your example doesn't do that - it shows the number of states added between January 2022 and the month in question (e.g. March only added 10 states from February, not 20), so I'm not sure which one you meant.

Of course, this also assumes that the formula you have correct reflects the number of added states. In many scenarios, 100 --> 110 could be e.g. 90 states retained, 10 removed, 20 new added.