topic Sorting in Pivot table in QlikView

Sorting in Pivot table

Wed, 12 Mar 2014 09:28:53 GMT

Hi,

Im currently creating a pivot table with 3 dimensions and 1 expression, Im facing with the custom sorting for the dimensions.

Please look at the redbox, I wish the outcome appear as the right chart, I have created the sorting column, and used in the left chart (Sort according to expression -> Sort column), but it still doesn't works, I was wondering was it due to the original loading set where there is another same description in row 10 (highlighted with blue circle)....

it only working right when I include the sorting column into chart, which not acceptable by my user, is there any one face this issue before or anyway to hide the sorting column from user ???

Solution needed... please...

Thanks,

Lyra

Re: Sorting in Pivot table

adiarnon — Wed, 12 Mar 2014 09:58:55 GMT

try in the Sort according to expression -

sum(Sort column)

Re: Sorting in Pivot table

er_mohit — Wed, 12 Mar 2014 09:59:26 GMT

Pivot table is better for grouping not sorting you can sort it on the basis of your first dimension

Re: Sorting in Pivot table

Wed, 12 Mar 2014 10:11:50 GMT

I understand that, but I still have to create a balance sheet report in that kind of layout to users... its a kind of grouping but thy want to have it in that sort of sequence for 2nd & 3rd dimension.

Re: Sorting in Pivot table

tresB — Wed, 12 Mar 2014 10:15:24 GMT

I would suggest to have a look at this blog post: How to Create a Profit and Loss Statement in QlikView

Re: Sorting in Pivot table

Wed, 12 Mar 2014 10:16:03 GMT

thanks for suggesting but it's not working ...

Re: Sorting in Pivot table

adiarnon — Wed, 12 Mar 2014 10:25:04 GMT

you need to check if the Sort according to expression -sum(Sort column) is on your second dimension

Re: Sorting in Pivot table

Thu, 13 Mar 2014 01:57:16 GMT

I have applied on the second dimension, but it still giving the wrong result. I also uncheck all the sorting for the First & third Dimension.

Re: Sorting in Pivot table

Sun, 01 Jun 2014 11:06:23 GMT

Hi Lyra

You could use match function in the expression

Please see the below

http://www.qlikfix.com/2010/10/25/creating-a-custom-sort-order/

Thanks and regards

Padma