topic Custom sort in Pivot table in QlikView

Custom sort in Pivot table

Fri, 31 Jan 2014 11:17:23 GMT

Hello,

I have a pivot table which has a dimension called "Period name". Period Name is a calculated dimension and is composed of two fields Year & Period

=Year1 & chr(10)&Period.

I have a problem with the sort order. The Period has its own sort order and the year has its own sort order. How can I combine both the sort orders in the pivot table?

The period and Year are in different table.

Attached is an example.

Thanks a lot in advance!

Re: Custom sort in Pivot table

Fri, 31 Jan 2014 11:20:18 GMT

Use this in sorting expression of PeriodName in Pivot:

max({1}YearId)+max({1}PeriodId)

Re: Custom sort in Pivot table

jvishnuram — Fri, 31 Jan 2014 11:20:42 GMT

Hi Warrior,

What is your expected output in this pivot.

Re: Custom sort in Pivot table

Gysbert_Wassenaar — Fri, 31 Jan 2014 12:48:51 GMT

Try sorting by =only({1}YearId)*100+only({1}PeriodId)

Re: Custom sort in Pivot table

Mon, 03 Feb 2014 08:21:43 GMT

This expression worked just fine!

Thanks a million!

Regards,

On Jan 31, 2014 12:21 PM, "Mario De Stefano" <qcwebmaster@qlik.com>

Re: Custom sort in Pivot table

Mon, 03 Feb 2014 10:09:44 GMT

Hi Hero,

please mark it as correct answer!

Regards