topic Re: Pivot table sorting in QlikView

Pivot table sorting

priyarane — Mon, 26 Jan 2026 18:19:17 GMT

Hi Community,

I wanted to perform sorting based on for ex; Sum(sales) - first expression in my pivot table and other too.

I have 4 calculated dimensions like

1. =if(IRB_WR_Type = 'Wholesale' ,if(isnull(IRB_Category),'CRR Unallocated',IRB_Category)) as Dim1

2. =if(IRB_WR_Type = 'Wholesale',if(IRB_Band = 'CRR_U',' ',IRB_Band)) as Dim2

3. =if(Match(IRB_Band,'CRR_U') > 0,' ',Num((IRB_Lower_Band*100),0.000)&'%') as Dim3

4. =if(Match(IRB_Band,'CRR_U') > 0,' ',Num((IRB_Higher_Band*100),0.000)&'%') as Dim4

How can I achieve this

Re: Pivot table sorting

sunny_talwar — Thu, 21 Jan 2016 15:32:14 GMT

Is there a sample that you can share?

Re: Pivot table sorting

priyarane — Thu, 21 Jan 2016 15:41:11 GMT

Hi Sunny,

It is huge qvw

Re: Pivot table sorting

dinuwanbr — Fri, 22 Jan 2016 09:40:18 GMT

Hi Priya,

Don't upload the full file. Just about few rows to understand your requirement.

Rgds,

tharindu

Re: Pivot table sorting

Anonymous — Fri, 22 Jan 2016 10:08:00 GMT

Sorting based on what??

A pivot table is always sorted first after the first dimension, then the second dimension, etc. This is necessary since the rows are grouped first after the first dimension, then the second dimension, etc. If you want to sort after an expression, you should use a straight table instead.

Re: Pivot table sorting

priyarane — Fri, 22 Jan 2016 11:01:38 GMT

Hi Balraj,

It is pivot. I need to sort on expression

Re: Pivot table sorting

priyarane — Fri, 22 Jan 2016 11:05:55 GMT

Hi,

I have added sample data.

I wanted to have sort based on Expression and pivot table

Re: Pivot table sorting

priyarane — Fri, 22 Jan 2016 11:06:21 GMT

Hi Sunny,

I have added sample data

Re: Pivot table sorting

Fri, 22 Jan 2016 11:14:38 GMT

sorting is not possible in pivot table instead of that you can use straight table for sorting

regards

ajay