Calculation between week and previous week

[bue]

Hi,

i am new to Qlik and try to do a calculation that says how many new ones have been added in comparison to the previous week.

To get the number of the new ones i am counting the date "Count(Created_Date)"

Now, i want to substract the counted Created_Date from the previous week, like that:

Count(Created_Date)	=Year([Created_Date_Neu]) & '-' & 'KW' & Week([Created_Date_Neu])	New
20	2021-KW51	20
23	2021-KW52	3
39	2022-KW1	16
38	2022-KW2	-1
44	2022-KW3	6

Does anybody know, how to calculate "New"?

Thanks in advance!

[ggijben · Accepted solution]

Hi @bue , 

Can you try: 

Count(Created_Date)  -  Above(Count(Created_Date))

This is a very simple solution that will work as long as you keep the table sorted chronologically.
A better option would be to use a calendar in your script so you can use flags. But this would require some data modelling in the script.

[bue]

It works! Thank you so much.