topic Re: Multi dimension sort in pivot in QlikView

Multi dimension sort in pivot

Wed, 05 Jun 2013 01:20:34 GMT

Hi all,

i have searched through the various threads in qlik community, but couldnt find solution for this issue..

Please refer to the pivot table in attached QVW file.. Actual pivot in my application is more complex than this with additional dimensions, etc.

The sample pivot has 2 dimensions and I would like to implement below sort order -

- first dimension should be sorted alphabetically

- second dimension should be first sorted by an expression using MNC_Integer and then by alphabetically.

Problem is some values from second dimension field has different MNC_Integer for corresponding TEAM_BNKR.... for example, HYUNDAI has MNC_Integer 2 for "LLL - BBB" whereas its 1 for "LLL - RRR"... in this case, Hyundai should appear after all MNC_Integer=1 clients...

Appreciate any help... thanks!

Re: Multi dimension sort in pivot

qliksus — Wed, 05 Jun 2013 10:51:21 GMT

Hi,

Could you please expalin how u want the output with snashot?

Re: Multi dimension sort in pivot

Wed, 05 Jun 2013 11:02:18 GMT

First dimension - LLB - BBB followed by LLL-RRR (already working)

Second dimension - within LLL - BBB and LLL-RRR, first sort by High, Med, Low and within each High/Med/Low bucket, sort client names alphabetically.

So for example, BANK OF BARODA should appear first for LLL-BBB and HYUNDAI should be after all the High clients.

Re: Multi dimension sort in pivot

Wed, 05 Jun 2013 12:20:08 GMT

Also tried with AutoNumberHash128 function to create a key using TEAM_BNKR, MNC_Integer, ENTTY_NM

But LLL - BBB, 2, HYUNDAI has lower key than LLL - BBB, 1, BANK OF BARODA..

I would have expected LLB - BBB, 1, BANK OF BARODA to get key as 1..

Re: Multi dimension sort in pivot

qliksus — Mon, 10 Jun 2013 08:33:31 GMT

Hi,

If you use straight table instead of Pivot, then you will get the desired output(Checked with Straight table , looks fine).

Is there any particular reason to use Pivot table?

Re: Multi dimension sort in pivot

vikasmahajan — Mon, 10 Jun 2013 10:03:18 GMT

Sorting for Multiple Dimensions not works in Pivot table you can use straight table insted of pivot table.

Vikas