Skip to main content

App Development

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

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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