Discussion board where members can get started with Qlik Sense.
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: I need a formula that makes a table like this: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!
Go to Solution.
Check the attached.
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.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!
Here is the solution with front end expression.