This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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!
Check the attached.
View solution in original post
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.