Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
RodrigoRodrigues
Contributor
Contributor

Get first entry for each user and sum on MonthYear

I need to get the minimum date for each user, and sum the number of dates that are on the same month/year.

Let me give a quick example this is a sample set: 

image.png

I need a formula that makes a table like this:

image.png

I already got the MonthYear, but I am having trouble to get the myFormula part.

Basically I need to get the MonthYear of the first entry of the user and sum with all other users that have the same MonthYear for their first entry. 

So we have 1 for Dec-2018 (Cesar - 11/12/18 -> First Entry)
2 for Jan-2019 (Julio 07/01/19 -> first entry and Bruno 25/01/19 -> First Entry)

I hope that what I need to achieve is clear.

Thanks!


Labels (1)
1 Solution

Accepted Solutions
neelamsaroha157
Specialist II
Specialist II

Check the attached.

View solution in original post

3 Replies
neelamsaroha157
Specialist II
Specialist II

Check the attached.

RodrigoRodrigues
Contributor
Contributor
Author

Thanks for the answer.

It actually worked as expected on your attachment, but I could not make it work on my file.

I have some doubts about your attached file.

image.png

Where are the fields MinDate coming from? I don't understand how this works.

Also, on my file I was using sum and aggr to try to get what I want. Is there a way of doing the same stuff you did on the load using some formula that is not on the load script?

Thanks!

neelamsaroha157
Specialist II
Specialist II

Here is the solution with front end expression.