topic Re: Sorting Problem in Pivot Table .. in QlikView

Sorting Problem in Pivot Table ..

Wed, 05 Aug 2015 07:24:51 GMT

Hi Frnz,

I have pivot table. In this, it is showing Top 15 Accounts. I have done pivoting on YEAR.

I need to do sorting by 2015 values ? Is it possible to show Totals in last row by year wise ?

Re: Sorting Problem in Pivot Table ..

Wed, 05 Aug 2015 07:37:56 GMT

I Don't think so row wise sorting in qlikview

Re: Sorting Problem in Pivot Table ..

krishna20 — Wed, 05 Aug 2015 07:40:02 GMT

Hi Tulasi,

Can you please attach sample file.It will be easy to sort out your problem .

Re: Sorting Problem in Pivot Table ..

Anonymous — Wed, 05 Aug 2015 07:48:08 GMT

I am not sure,but give it a try

goto sort tab and select your expression

define: =sum({<YEAR={'2015'}>}Value) descending

Re: Sorting Problem in Pivot Table ..

Wed, 05 Aug 2015 07:53:41 GMT

Hi,

Please check attached Qvw. I need Sorting in 2015 values. And is it possible to show Totals in Year wise.?

Re: Sorting Problem in Pivot Table ..

Wed, 05 Aug 2015 08:10:56 GMT

Hi,

I need descending order for 2015 values. Please find the attached QVW.

Re: Sorting Problem in Pivot Table ..

Digvijay_Singh — Wed, 05 Aug 2015 08:30:13 GMT

Doesn't look easy in Pivot table, below is relevant post on this -

Sorting in pivot tables

Re: Sorting Problem in Pivot Table ..

krishna20 — Wed, 05 Aug 2015 08:37:48 GMT

Hi ,

Is this???

Re: Sorting Problem in Pivot Table ..

Anonymous — Wed, 05 Aug 2015 08:39:34 GMT

Hi!
You should use the expression:

sum({<Year={"2015"}>}Sales)

Put it in your sorting tab under AccountName, make sure its descending, and that al other sorting under Year is off.

Re: Sorting Problem in Pivot Table ..

Wed, 05 Aug 2015 09:22:03 GMT

Hi,

Yes exactly i need like this. When I use this expression, I am getting like below image. I need 2015 values in top of the table.

Re: Sorting Problem in Pivot Table ..

Wed, 05 Aug 2015 09:29:40 GMT

Sorry..It is working JMStekkinger solution.

Re: Sorting Problem in Pivot Table ..

Anonymous — Wed, 05 Aug 2015 09:30:19 GMT

Well, I dont know why it doesnt work for you.

I would like to send you the file, but I do not see the option to add an attachment.

Re: Sorting Problem in Pivot Table ..

Anonymous — Wed, 05 Aug 2015 09:30:36 GMT

Oh good

Re: Sorting Problem in Pivot Table ..

Wed, 05 Aug 2015 09:32:25 GMT

Hi,

It is working no problem. Thanks for your solution..

And is it possible to show Totals in last row for every Year?