I need to sort elements from a Dimension in a pivot table.

Wed, 25 Nov 2020 16:16:04 GMT

Here is the example expression which i tried in the qlik sense :

if(MATCH(Column_ID1,1,2)>=1 and MATCH(Column_ID2,'V/O')= 0,'V + R', as 1

if( MATCH(Column_ID1,3,4,5)>=1 and ((MATCH(Column_ID2,'V/O')= 1 and MATCH(Column_ID3,'D')= 1) or (MATCH(Column_ID2,'R')=1)),'V/R Days 1-3', as 2

if(MATCH(Column_ID1,6,7,8,9)>=1 and MATCH(Column_ID2,'R')= 1 ,'VR Days 4-7', as 3

if((MATCH(Column_ID1,1,2,3,4,5)=0 and MATCH(Column_ID2,'V/O')= 1 and MATCH(Column_ID3,'D')= 1 ) or

(MATCH(Column_ID1,1,2)=0 and MATCH(Column_ID2,'V/O')=1 and (MATCH(Column_ID3,'D')= 0 OR ISNULL(Column_ID3)))

,'VR 4-35 + A 1-35', as 4

if(MATCH(Column_ID1,1,2,3,4,5,6,7,8,9)=0 and MATCH(Column_ID2,'R')= 1 ,'VR Days 8-35' as 5 )))))

I need to get in the same order which is present in the expression : a. V + R

b. V/R Days 1-3

c. VR Days 4-7

d. VR 4-35 + A 1-35

e. VR Days 8-35 and need to sort on ID as alias names

Please help in this.

Re: I need to sort elements from a Dimension in a pivot table.

ramasaisaksoft — Mon, 23 May 2016 11:09:07 GMT

Hi Varun,

Can you write the same Expression in in Number tab and select the first Dimension(and select Expression radio button copy paste your expression here) so that this Dim will sort depends on the Expression.

Re: I need to sort elements from a Dimension in a pivot table.

Tue, 24 May 2016 05:03:29 GMT

Hi Rama Sai ,

This Script am using in Qlik sense not in Qlik View.

Please if you have any idea in Qlik sense let me know.

Thanks in advance.

topic Re: I need to sort elements from a Dimension in a pivot table. in QlikView

I need to sort elements from a Dimension in a pivot table.

Re: I need to sort elements from a Dimension in a pivot table.

Re: I need to sort elements from a Dimension in a pivot table.