Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
c_latham
Contributor III
Contributor III

Match Sort Order

Hi All,

I have a dimension of 'Hour' which is an expression: hour(t_put)

I want to set the order of this dimension to be:

22,23,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21

So I used the following on the sort order:

Match(hour(t_put),'22','23','0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21')

However, I am getting a sporadic order which doesn't look like I expect.

Can anyone advise on what I have done wrong?

Thanks!

Labels (1)
  • Match

1 Solution

Accepted Solutions
sunny_talwar

Can you try this

Only({1} Match(Hour(t_put), 22, 23, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21))

View solution in original post

3 Replies
sunny_talwar

Can you try this

Only({1} Match(Hour(t_put), 22, 23, 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21))
c_latham
Contributor III
Contributor III
Author

Perfect, thanks Sunny!

mahendrankr
Contributor III
Contributor III

Awesome! I was stuck with this issue for quite long time.. Thanks Sunny