topic Re: help with sorting in Pivot table in QlikView

help with sorting in Pivot table

Anonymous — Fri, 02 May 2014 15:22:33 GMT

Please see the attached QVW and screen shot which will explain my problem. Thanks for your help in advance.

Re: help with sorting in Pivot table

Anonymous — Fri, 02 May 2014 15:29:58 GMT

any help on this...

Re: help with sorting in Pivot table

sudeepkm — Fri, 02 May 2014 15:37:22 GMT

if you have sorted the table based on one expression then when you try to sort it again based on another expression then the first sorted one will be lost.

In pivot table interactive sort is not possible, you may try straight table or you can create buttons based on whose value you can follow a particular sorting.

Re: help with sorting in Pivot table

giakoum — Fri, 02 May 2014 15:42:31 GMT

Could you please explain more? if column style is sorted, you cannot have the columns sorted ascending as well.

Re: help with sorting in Pivot table

Anonymous — Fri, 02 May 2014 15:46:28 GMT

Hi Sandeep,

Thank you for your reply... the reason i am restricted not to use straight table is because they want the partial sums for each category. Not sure how we can get for straight table.

Re: help with sorting in Pivot table

Anonymous — Fri, 02 May 2014 15:49:57 GMT

Hi vinay,

you can apply this method

http://community.qlik.com/thread/114072

hope it helps

sri1

Re: help with sorting in Pivot table

Clever_Anjos — Fri, 02 May 2014 16:57:23 GMT

Remember that you can have subtotals into a straight table, ticking 'Total' into Dimension Limits tab

Re: help with sorting in Pivot table

Anonymous — Fri, 02 May 2014 17:27:37 GMT

Hi Srikanth,

I asked our Business partner they haven't agreed for that. But i will try to push through my manager.

Re: Re: help with sorting in Pivot table

Anonymous — Fri, 02 May 2014 17:31:38 GMT

Hi Ioannis ,

Sorry for the late reply. Please see attached screen shot how the output should look like..@

Re: Re: help with sorting in Pivot table

Anonymous — Fri, 02 May 2014 17:31:58 GMT

I will try like this.

Re: help with sorting in Pivot table

Anonymous — Fri, 02 May 2014 18:07:58 GMT

Hi Clever,

Once we apply this can we do sorting for each category in dimension1.

Re: help with sorting in Pivot table

Clever_Anjos — Fri, 02 May 2014 19:24:28 GMT

You can sort by any column (dimension or expression).

If you want to block this, go to Sort Tab, configure your sorting as desired and uncheck "Allow ..."

Re: help with sorting in Pivot table

Anonymous — Fri, 02 May 2014 19:44:38 GMT

Hi Clever, i am the check box is disabled for me . ... can you please help me with that.

Re: Re: help with sorting in Pivot table

Clever_Anjos — Fri, 02 May 2014 19:53:16 GMT

This checkbox? Anyway, sending a demo (PFA)

Re: Re: Re: help with sorting in Pivot table

Anonymous — Fri, 02 May 2014 20:01:39 GMT

Hi Clever,

I am confused. Can you please help me in the attached qvw file.

Re: Re: Re: Re: help with sorting in Pivot table

Clever_Anjos — Sat, 03 May 2014 00:15:41 GMT

PFA

Re: help with sorting in Pivot table

Anonymous — Wed, 07 May 2014 20:26:51 GMT

Hi Clever,

I was sick this two days sorry for the late reply but in the attached document the sold below targeted margin and sold above targeted margin are not is descending order. Please let me know if i am missing anything.

Re: help with sorting in Pivot table

Clever_Anjos — Thu, 08 May 2014 11:23:57 GMT

Hope you´re better now from your sickness.

You can go to Sort Tab and configure any sort order you want.

It´s just an example.