How do you sort by an aggregated date??

[QlikkitySplits]

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.

[sergio0592]

Hi,

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

[Brett_Bleess]

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