Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Cycle Group Demension Sort Issue

=if(Week < vCurrentWeek, Week, if(Week = vCurrentWeek, Week & ' - ' & DayOfWeek))


I currently have this as an expression within my date cycle group dimensions. It properly sorts the weeks from 13-1 (current week - previous). But the if statement says if it is the current week then load the days. So the result is as follows if it is current week 14 - 1 (1 being a day of week). However, the 14 shows up at the bottom of the weeks under 1 So when viewing the strait table the dimensions list as follows.


13
12
11
.
.
.
1
14 - 1
14- 2
14 - 3
14 -4


I want the 14 to be on top. Any suggestions?

Thanks

11 Replies
Not applicable
Author

John, that works. except now it is showing mon-fri even though I want it to only show currentday -1 (yesterday).


Any thoughts?

Thanks,

Not applicable
Author

Actually i just added back my if statement in your example. Works great, thank you!