Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ramshoney
Contributor

Re: Selecting on map shows to relevant text data in Textbox.

I also got the same doubt, when I look into data

2017 year

11 month

7 day

8 hours

shraddha_g
Honored Contributor III

Re: Selecting on map shows to relevant text data in Textbox.

can you change it to some other format?

ramshoney
Contributor

Re: Selecting on map shows to relevant text data in Textbox.

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.

shraddha_g
Honored Contributor III

Re: Selecting on map shows to relevant text data in Textbox.

Do you have year month day and hour in different columns then share it as it is

ramshoney
Contributor

Re: Selecting on map shows to relevant text data in Textbox.

Shraddha, Please find the attachment for the sample file.

ramshoney
Contributor

Re: Selecting on map shows to relevant text data in Textbox.

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.

Highlighted
shraddha_g
Honored Contributor III

Re: Selecting on map shows to relevant text data in Textbox.

good!

ramshoney
Contributor

Re: Selecting on map shows to relevant text data in Textbox.

Thanks, Shraddha.

Community Browser