Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
niharika1234
Creator
Creator

Sort on column

Hello,

I have a Table with 5 field in the following order. user wants to sort order like Tier-1, Tier II, Tier-III, High, Medium, Low.  Please suggest.

Untitled3.png

1 Solution

Accepted Solutions
niharika1234
Creator
Creator
Author

Thanks a lot. It worked.

View solution in original post

4 Replies
dimitree
Partner - Contributor
Partner - Contributor

 

Hi, you have to create another one column with the sorting order and put it as an expression into the sorting option of the desired visualization.

2018-11-16 17_18_39-Skype for Business.png

MAP:
MAPPING LOAD * Inline [
	A, Ord
    High, 4
    Low, 5
    Tier1, 1
    Tier2, 2
    Tier3, 3
];
LOAD *, ApplyMap('MAP', A) AS Ord;
LOAD * INLINE [
    A
    High
    Low
    Tier1
    Tier2
    Tier3
];	

 

m_woolf
Master II
Master II

or you can sort by expression"

match(Priority,'Tier-1','Tier II','Tier-III','High','Medium','Low')

niharika1234
Creator
Creator
Author

Thanks .
niharika1234
Creator
Creator
Author

Thanks a lot. It worked.