topic Re: Sorting order in QlikView

Sorting order

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

Hi All ,

I just want to show below sorting order in below application (piovt table ), can any help me out on this?

below is the attached file

Gross Sales--1
Good returns--2
Bad returns--3
Discounts--4
Free goods --5
Invoiced Sales--6
Rebates -7
Net Sales-8

Re: Sorting order

Gysbert_Wassenaar — Thu, 19 May 2016 08:21:03 GMT

You can determine the load order in the script by first loading the values in the order you want:

TempLevel1;

LOAD * INLINE [

Level 1

Gross Sales

Good returns

Bad returns

Discounts

Free goods

Invoiced Sales

Rebates

Net Sales

];

[P&L Hier1]:

LOAD ACCN_INSIGHT_CD,
     [Level 1],
     [Level 2],
     [Level 3],
     [Level 4],
     [Level 5],
     [Level 6]
FROM
     [ ..\4.Mart\P&L Hier1.xls]
     (biff, embedded labels, table is Sheet1$)

;

DROP TABLE TempLevel1;

You can then sort Level 1 by Load Order in your pivot table.

Re: Sorting order

alexandros17 — Thu, 19 May 2016 08:23:18 GMT

Take a look at this:

Re: Sorting order

Anonymous — Thu, 19 May 2016 08:38:02 GMT

Hi,

It's not showing correct order..

Re: Sorting order

Gysbert_Wassenaar — Thu, 19 May 2016 09:03:08 GMT

You mean in that monster pivot table CH396 on the sheet Direct Sales Vs Indirect Sales? If you want that monster sorted by Level 1 first and then the other dimensions then you need to move that field to the left most position in the pivot table.

Re: Sorting order

Anil_Babu_Samineni — Thu, 19 May 2016 09:07:56 GMT

Like this..

=match([Level 1],'Gross Sales','Good returns','Bad returns','Discounts','Free goods','Invoiced Sales','Rebates','Net Sales')

Re: Sorting order

Anonymous — Thu, 19 May 2016 15:27:11 GMT

below is the correct one

Thank you guys for trying

if([Level 1] = 'Gross Sales',1, if([Level 1] = 'Good Returns',2, if([Level 1] = 'Bad Returns',3, if([Level 1] = 'Discount',4,

if([Level 1] = 'Free goods',5, if([Level 1] = 'Invoiced Sales',6, if(Upper(Trim([Level 1])) ='Rebates ',7,

if(lower([Level 1]) ='Net Sales',8,9998))))))))

Re: Sorting order

Anil_Babu_Samineni — Thu, 19 May 2016 15:32:17 GMT

Time G_D..

If possible, Please share me that Qvw file / Let me know where do you paste this code...