Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bumin
Partner - Creator II
Partner - Creator II

sort order in pivot table

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

5 Replies
RSvebeck
Specialist
Specialist

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

Svebeck Consulting AB
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

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

Celambarasan

bumin
Partner - Creator II
Partner - Creator II
Author

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

bumin
Partner - Creator II
Partner - Creator II
Author

Hi,

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

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

regards

Bumin

bumin
Partner - Creator II
Partner - Creator II
Author

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