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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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.