Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.