topic Re: sorting pivot table in QlikView

sorting pivot table

kris_vliegen — Tue, 25 Aug 2015 14:37:50 GMT

Hi all,

How can I sort this? Pumpprice from 15:00 hoours from smaal to large?

Regards Kris

Re: sorting pivot table

Qrishna — Tue, 25 Aug 2015 14:46:10 GMT

try 'numeric value' descending.

if that doesnt work,try using expression in the sort: rank([ total ] expression [ , mode [, format ] ]).

Re: sorting pivot table

kris_vliegen — Tue, 25 Aug 2015 14:50:08 GMT

The numeric value doesn't work.

The expression I use to calculate the FuelPrice is =avg(Pump_price)

What should I use in the sort expression?

Re: sorting pivot table

settu_periasamy — Tue, 25 Aug 2015 14:50:39 GMT

Hi,

What about calc_Date_time sort by Ascending in Numeric value.?

if it is not working, try to upload the sample file?

Re: sorting pivot table

Qrishna — Tue, 25 Aug 2015 14:51:14 GMT

could you please attach some data?

Re: sorting pivot table

ChiragPradhan — Tue, 25 Aug 2015 14:55:28 GMT

Try Num(PumpPrice) in expression and sort ascending.

-Chirag

Re: sorting pivot table

kris_vliegen — Tue, 25 Aug 2015 14:57:56 GMT

Then I got this

Re: sorting pivot table

ChiragPradhan — Tue, 25 Aug 2015 15:16:30 GMT

Can you attach the data you are working with?

Re: sorting pivot table

kris_vliegen — Wed, 26 Aug 2015 07:24:50 GMT

I'm going to try to create a small dashboard with the problem.

Re: sorting pivot table

kris_vliegen — Wed, 26 Aug 2015 07:48:05 GMT

Hi All, here is an example of my pivot-tabel.You should select one mintijd.latitude and then he should sort the data.

REgards,

Kris

Re: sorting pivot table

settu_periasamy — Wed, 26 Aug 2015 08:35:20 GMT

Not able to open your document. is anyone have the same issue?

Re: sorting pivot table

kris_vliegen — Wed, 26 Aug 2015 08:41:02 GMT

Can you try it now. There was section access in it. Now it should work.

My excuses for this...

Regards,

Kris

Re: sorting pivot table

ChiragPradhan — Wed, 26 Aug 2015 09:08:40 GMT

Still does not work. Access denied.

Re: sorting pivot table

kris_vliegen — Wed, 26 Aug 2015 09:25:02 GMT

And this one?

Re: sorting pivot table

ChiragPradhan — Wed, 26 Aug 2015 09:35:19 GMT

Re: sorting pivot table

kris_vliegen — Wed, 26 Aug 2015 09:40:21 GMT

If this one doen't work I don't now how to delete the sectionaccess.

Re: sorting pivot table

settu_periasamy — Wed, 26 Aug 2015 09:54:59 GMT

Try the attachement..

Re: sorting pivot table

kris_vliegen — Wed, 26 Aug 2015 10:00:50 GMT

No, it isn't working on my pc.

And if it is possible I would like to see the newest date in front.

Re: sorting pivot table

ChiragPradhan — Wed, 26 Aug 2015 10:21:41 GMT

this one is opening..

Re: sorting pivot table

ChiragPradhan — Wed, 26 Aug 2015 10:57:19 GMT

I have tweaked settu_periasamy‌ document slightly and attached here. Sort in pivot is going to be a bit tricky due to multiple dimensions. Since you are using a dimension group here, you have to ensure that the sort orders for each dimension in the group are aligned and you will need to drill down into each dimension for the sort to work.

HTH

Chirag