topic Re: sort order in pivot table in QlikView

sort order in pivot table

bumin — Fri, 27 Apr 2012 13:20:15 GMT

Hi,

I have a problem with the sort order in a pivot table.

I want to have the same sort order as in the original data.

When I look to the column H4 within column H3='liab' H4 is not sorted like the original data. When I select H3='liab' the the sort order is correct.

What I am doing wrong?

see original data in Excel and the appropriate qvw.

thanks for any help

Bumin

Re: sort order in pivot table

RSvebeck — Fri, 27 Apr 2012 15:21:51 GMT

Hi. Remove all sorting from the pivot and you will end up with the same soring as in excel. See attached. //Robert

Re: sort order in pivot table

CELAMBARASAN — Fri, 27 Apr 2012 15:27:45 GMT

Hi,

Use the Sort by load order for all the columns.It will provide you same as the original load order.

Celambarasan

sort order in pivot table

bumin — Sat, 28 Apr 2012 14:00:11 GMT

Hi Robert,

the sort oder is nok ok in your example

When you look into

H1=bs

H2=eqLiab

H3=liab

the column H4 has wrong sort order

regards

Bumin

sort order in pivot table

bumin — Sat, 28 Apr 2012 14:01:56 GMT

Hi,

this is what I thougt also. but it is not the case.

H4=other occurs several times. Is this the problem?

regards

Bumin

Re: sort order in pivot table

bumin — Sat, 28 Apr 2012 16:33:15 GMT

I managed to find the rigth sort order.

The problem was that the text "other" exists several times in different H3-Fileds

h3=prepaid expences H4=other

h3=accruals H4=other

h3=liab H4=other

etc...

in the script I have combined the fields H3 and H4 into H4

H3&'_'&H4 as H4

and the sort order is now OK.

In my diagram I have removed the digits until the first "_" to show only the original H4 value.

My solution is a little bit tricky. Is there any better more straigth away solution for that kind of data?

thanks and regards

Bumin