Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
Sameer9585
Contributor 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
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

 

Sameer9585
Contributor II

Re: Count Monthly

Hi @rodjager,
Thanks for your reply but the app you have given is not correct in my scenario I required
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

Channa
Valued Contributor III

Re: Count Monthly

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

Channa
Sameer9585
Contributor II

Re: Count Monthly

I am using Year of Date of Resignation.
Sameer9585
Contributor II

Re: Count Monthly

I want in the load script editor