Discussion board where members can get started with Qlik Sense.
I am struggling with finding a way to know the minimum date of each day for each user in QlikSense
This is the data I have: (date of login is M/D/YYYY)
What I want to get is the following:
Thank you in advance
Go to Solution.
take the day as filter from date field.
the in straight table take the dimensions are Day, User Id,record type.
aggr(MinString([date of login]),[user id],Day)
.then if you want you can hide the Day in presentation tab.
use the expression
Aggr(Min([date of login]),[user id])
Aggr(Minstring([date of login]),[user id])
Thank you for your reply.
This works if I want to get the minimum date for each user Id, but it doesn't get me the minimum date for each of the days.
I want to be able to have only the first date (minimum date) for each day that the User ID has a record.
why is the user 808 repeated 2 times in your expected output ?
as you said you need to find min date of login for each user , am surprised to see 2 entries for 808 ?
i have tried table with userid, recordtype as DIM and =Aggr(Minstring(dologin),userid) as expr .
Can you check
The reason why I have the user 808 repeated 2 times is that I want to have the minimum date for each day.
In this case, user 808 has a record in 2 days, so I want to present both days
Thank you for your reply
May be try
TimeStamp(Timestamp#([date of login],'M/D/YYYY h:mm:ss TT'),'M/D/YYYY h:mm:ss TT') As [date of login],
Date(Floor(Timestamp#([date of login],'M/D/YYYY h:mm:ss TT')),'M/D/YYYY') As [date of login1],
user id,date of login,record type
303,1/2/2017 1:04:24 PM,type1
303,1/2/2017 2:01:39 PM,type1
303,1/2/2017 2:03:31 PM,type1
808,1/3/2017 1:02:21 PM,type1
808,1/4/2017 4:04:24 PM,type1
[date of login1],
Min([date of login]) as [date of login],
1 As Flag
[date of login1]
Thank you for your reply !
It's what I was looking for.