Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Count Monthly

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,

6 Replies
Highlighted
Partner
Partner

Re: Count Monthly

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

 

Highlighted
Creator II
Creator II

Re: Count Monthly

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

Re: Count Monthly

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

Highlighted
Specialist III
Specialist III

Re: Count Monthly

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

Channa
Highlighted
Creator II
Creator II

Re: Count Monthly

I am using Year of Date of Resignation.
Highlighted
Creator II
Creator II

Re: Count Monthly

I want in the load script editor