topic Re: Sorting timestamps in QlikView

Sorting timestamps

tka_ovako — Wed, 25 Nov 2020 16:16:04 GMT

Hello.

I have scrip that link Year and Month:

num(Year (timestamp(max(EventEndDate)))) & num(Month (timestamp(max(EventEndDate)))) as EventEndYearMonth

however in chart I get wierd compination:

After 20169 come 20171 and after 20182 come 201610 an so on. I know this is some kind onf soting problem but how I fix it?

Timo

Clever_Anjos — Tue, 20 Feb 2018 10:59:54 GMT

Please try with

Year (timestamp(max(EventEndDate))) *100 + Month (timestamp(max(EventEndDate)))

YoussefBelloum — Tue, 20 Feb 2018 11:09:09 GMT

Hi,

try to set the sorting of your dimension to: numeric value ascending

and uncheck the rest

chinnuchinni — Tue, 20 Feb 2018 11:12:26 GMT

Use below script for Month,You will get your require result

=num(Month (timestamp(max(EventEndDate))),'00')

chinnuchinni — Tue, 20 Feb 2018 11:17:23 GMT

=num(Year (timestamp(max(EventEndDate))))&num(Month (timestamp(max(EventEndDate))),'00') as EventEndYearMonth

tka_ovako — Tue, 20 Feb 2018 11:22:35 GMT

Thank you Clever. That Works. Also praveen's solution seems to work!