Qlik Community

QlikView Administration

Discussion Board for collaboration on QlikView Management.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Pivot table sorting

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

8 Replies
sunny_talwar

Is there a sample that you can share?

priyarane
Specialist
Specialist
Author

Hi Sunny,

It is huge qvw

dinuwanbr
Creator III
Creator III

Hi Priya,

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

Rgds,

tharindu

balrajahlawat
Champion
Champion

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.

priyarane
Specialist
Specialist
Author

Hi Balraj,

It is pivot. I need to sort on expression

priyarane
Specialist
Specialist
Author

Hi,

I have added sample data.

I wanted to have sort based on Expression and pivot table

priyarane
Specialist
Specialist
Author

Hi Sunny,

I have added sample data

Not applicable

Hi

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

regards

ajay