topic Re: Sort Order Missing in Pivot Table in QlikView

Sort Order Missing in Pivot Table

priyarane — Mon, 27 Apr 2015 09:50:55 GMT

Hi Experts,

In pivot table sort order missing.

I have attached screen shots

1. Sort order qv

2. Sorurce order.

I have checked sort order as LOAD ORDER. Rest of the things are fine only these two only has issue.

Re: Sort Order Missing in Pivot Table

Gysbert_Wassenaar — Mon, 27 Apr 2015 09:57:09 GMT

Your screenshots don't give us enough information. Pivot tables are a bit bothersome with regards to sorting. Can you post a qlikview document that demonstrates your problem?

Re: Sort Order Missing in Pivot Table

priyarane — Mon, 27 Apr 2015 10:18:58 GMT

Hi Gysbert,

here is my app

Re: Sort Order Missing in Pivot Table

Gysbert_Wassenaar — Mon, 27 Apr 2015 10:26:58 GMT

And what is the problem? I don't see any missing sort orders. They are as you defined them. How do you want the pivot table to be sorted?

Re: Sort Order Missing in Pivot Table

priyarane — Mon, 27 Apr 2015 10:46:12 GMT

As I attached in QV-Sort.

I marked some Data, that should be first not in some where

Re: Sort Order Missing in Pivot Table

Mon, 27 Apr 2015 10:55:04 GMT

create inline load for sort order call that flag as sort by expression

Re: Sort Order Missing in Pivot Table

priyarane — Mon, 27 Apr 2015 11:13:53 GMT

Hi Manjunath,

Could you please elaborate

Re: Sort Order Missing in Pivot Table

Mon, 27 Apr 2015 11:24:27 GMT

Send me the sample so that i can able to elaborate and give the solution

Thanlks

Manju

Re: Sort Order Missing in Pivot Table

priyarane — Mon, 27 Apr 2015 11:32:18 GMT

Hi Manjunath,

Here is the data

Re: Sort Order Missing in Pivot Table

Mon, 27 Apr 2015 16:12:16 GMT

can u explain what exactly your looking for i gone through the your attach file am not getting your requirment