Discussion board where members can get started with Qlik Sense.
I also got the same doubt, when I look into data
can you change it to some other format?
I tried 2 - 3 format to change the format, by concat of ( Year, Month, Day, Hour) its not working any thing.
if we have any option we can convert them into date format and can sort it. But the issue im facing is how to add hours to the data and make it to a date format.
Do you have year month day and hour in different columns then share it as it is
Shraddha, Please find the attachment for the sample file.
Shraddha, I have used the below logic to get the individual salesrep top 5 Records.
1.) I converted the Year, Month,Day into Date format in the load editor by taking as new column.
Date(Floor(MakeDate("Year","Month","Day"))) as Date1
2.) Created a metric with Top 5 Tweets as Rank
=If(Aggr(Rank(Aggr(Only(Date1), [Salesrep], [TextName]), 3, 1), [Salesrep], [TextName]) <= 5,
Aggr(Rank(Aggr(Only(Date1),[Salesrep], [TextName]), 3, 1), [Salesrep], [TextName])
Got Some good results.