Count Monthly

[Sameer9585]

Hi,

I have a dataset which is having ID,Termination and Resignation and now I need the count of ID who have applied for resignation month wise and next is that I need to create an other measure in such a way that I need the cumulative difference from complete count of ID monthly.

Ex: If total 10 are there and 2 left on Jan I need Count as 8,if 3 left on feb I need count as 8-3=5 so on..

Below I provide the data set I am using in it Sheet 3 is to be focused.

Thanks,

[rodjager]

Hi Sameer9585,

Attached is a basic Qlik Sense app which gives the cumulative measure values based on the resignation date. 

Hopefully this gives you something to work from.

Kind regards,

Rod

[Sameer9585]

Hi @rodjager,
Thanks for your reply but the app you have given is not correct in my scenario I required

[rodjager]

Hi Sameer9585,

In your data, what is the date to base the calculation from or are you wanting to base the calculation off a point in time / snapshot date?

Kind regards,

Rod

[Channa]

=Aggr(RangeSum(Above(sum(Value),0,Rowno())),Date)

[Sameer9585]

I am using Year of Date of Resignation.

[Sameer9585]

I want in the load script editor