topic How do you sort by an aggregated date?? in QlikView

How do you sort by an aggregated date??

QlikkitySplits — Sat, 16 Nov 2024 20:23:06 GMT

How do you sort by a date function? i have a dimension like this

=Week([timestamp])

and then i have two measures, one with the f times another field, [value], is "Yes" and another for "No"

how do i make the data go in ascending order by week?

I overall find Qlik to be very limiting and frustrating, and cannot believe that sorting by Date ASC is not built into it... my bone to pick.

Re: How do you sort by an aggregated date??

sergio0592 — Thu, 25 Jul 2019 17:21:02 GMT

Hi,

Try with Sort/ Sort by expression and put your formula =Week([timestamp])

Re: How do you sort by an aggregated date??

Brett_Bleess — Mon, 19 Aug 2019 21:58:20 GMT

Check the following Design Blog links, hopefully they get you on the right track here, feel free to search in that area directly yourself as well if I missed the mark on the ones I selected.

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

https://community.qlik.com/t5/Qlik-Design-Blog/Why-don-t-my-dates-work/ba-p/1465849

There are others out there, just FYI, but I did not want to go too crazy here, here is the base URL to that area to search yourself:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Be sure to also use help.qlik.com as well...

Regards,
Brett