Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
buster22
Contributor II
Contributor II

Sorting Pivot Table Depending on measure

Is there a way to sort the pivot table depending on the value measure which i called status. I have tried to sort using the dimension  'A' . Using : If([status]='Urgent', '1') to try and make sure urgent goes to the top. I would like urgent to be at the top for the latest dates. Thanks 

Sorting Pivot Table.png

Labels (1)
4 Replies
raji6763
Creator II
Creator II

hi Buster,

  • under the sorting tab,you can sort by  expression
  • you can customize your sorting order using  below expression
  • match([status],'Urgent','2 weeks ago','X') based on your order
  • then Urgent will be at the top.

raji6763_0-1589354037843.png

 

regards,

raji

buster22
Contributor II
Contributor II
Author

I tried to match using the dimension A using the match on the measure 'Status' but this doesn't seem to work.

 

Sortiing Option.png

raji6763
Creator II
Creator II

Did you uncheck the sort by numerically &alphabetically?

match function is a case sensitive .could you please check spelling ,space & upper lower cases in that field value.

 

raji6763_1-1589364959854.png

 

raji6763_0-1589364951670.png

 

buster22
Contributor II
Contributor II
Author

Yes I have, I have used match before for a straight table but can't get it to work for this pivot table. thanks for the help.