Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
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
Partner

 

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.

View solution in original post