Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Use this in sorting expression of PeriodName in Pivot:
max({1}YearId)+max({1}PeriodId)
Use this in sorting expression of PeriodName in Pivot:
max({1}YearId)+max({1}PeriodId)
Hi Warrior,
What is your expected output in this pivot.
Try sorting by =only({1}YearId)*100+only({1}PeriodId)
This expression worked just fine!
Thanks a million!
Regards,
On Jan 31, 2014 12:21 PM, "Mario De Stefano" <qcwebmaster@qlik.com>
Hi Hero,
please mark it as correct answer!
Regards
MC