topic Re: Sort on column in QlikView

Sort on column

niharika1234 — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Sort on column

dimitree — Fri, 16 Nov 2018 16:21:08 GMT

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.

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
];

Re: Sort on column

m_woolf — Fri, 16 Nov 2018 16:24:08 GMT

or you can sort by expression"

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

Re: Sort on column

niharika1234 — Fri, 16 Nov 2018 16:46:07 GMT

Thanks .

Re: Sort on column

niharika1234 — Fri, 16 Nov 2018 16:46:26 GMT

Thanks a lot. It worked.