topic Help with sort order in QlikView

Help with sort order

hopkinsc — Fri, 08 Jun 2012 09:28:34 GMT

Hi all,

I am having trouble getting a sort order correct to a clients needs.

I have the following sort orders in the script.

LOAD * INLINE[
Bill_Class_Model,Sort_Order1
U,1
A,2
M,3
];
LOAD * INLINE[
Account_Det_ID_Model,Sort_Order2
DU,1
CU,2
CM,3

DM,4
];

What they want is if Bill_Class_Model = M then Sort_Order2 needs to be sorted in descending order otherwise sort in ascending order.

Can anyone help please?

Help with sort order

Fri, 08 Jun 2012 09:44:46 GMT

I try to put an expression like this in the tab order:

= If (Bill_Class_Model = 'M', (-1) * Sort_Order2, Sort_Order2)

Check ascending order.

A greeting.

Help with sort order

hopkinsc — Fri, 08 Jun 2012 09:53:02 GMT

Hi Daniel,

That didn't work. The field i am sorting is all in ascending order

I am struggling with this problem..

Help with sort order

hopkinsc — Fri, 08 Jun 2012 09:55:20 GMT

I don't know if it makesd a difference but i am trying to sort the data in a pivot table

Re: Help with sort order

Fri, 08 Jun 2012 10:14:05 GMT

I am attaching a document with an example.

I hope that helps you serve, if I understand you.

If you select the value of M, see you descending order.

A greeting.

Re: Help with sort order

hopkinsc — Fri, 08 Jun 2012 10:21:55 GMT

Hi again,

I have attached your sample, I have added the field Bill_Class_Model to the pivot table, as you can see it all shows ascending order.

It worked if the Bill_Class_Field was not part of the pivot table, but as you can see it doesn't wotk with that field added in..

It works if i select Bill_Class_Model U, i want it to work without any selections though.

This is how i want it to look:

Bill_Class_Model Account_Det_ ID_Model

U DU

A DU

M DM

Re: Help with sort order

jonathandienst — Fri, 08 Jun 2012 10:38:48 GMT

Use dual values, with the sort order the numeric value. You can then sort the values using numeric sorting. Modify your loads as follows:

LOAD Dual(Bill_Class_Model, Sort_Order1) As Bill_Class_Model //, SortOrder1 // remove comment if you still need SortOrder1/2

[

Bill_Class_Model, Sort_Order1

....

]

Make sure you change the sort to numeric.

Hope that helps

Jonathan

Re: Help with sort order

hopkinsc — Fri, 08 Jun 2012 12:18:42 GMT

Hi Jonathan, sorry, what do i need to change my scipt to please?

Re: Help with sort order

jonathandienst — Sun, 10 Jun 2012 18:13:27 GMT

Replace the first LOAD* INLINE with

LOAD Dual(Bill_Class_Model, Sort_Order1) As Bill_Class_Model

Replace the second LOAD * INLINE with

LOAD Dual(Account_Det_ID_Model, Sort_Order2) As Account_Det_ID_Model

Re: Help with sort order

hopkinsc — Mon, 11 Jun 2012 08:04:36 GMT

Hi Jonathan,

I have replaced what you have said but i am getting syntax errors. Have i done something wrong?

Re: Help with sort order

jonathandienst — Mon, 11 Jun 2012 18:08:56 GMT

Sorry, my mistake. Should be

LOAD Dual(Bill_Class_Model, Sort_Order1) As Bill_Class_Model INLINE

and

LOAD Dual(Account_Det_ID_Model, Sort_Order2) As Account_Det_ID_Model INLINE

Jonathan

Re: Help with sort order

hopkinsc — Tue, 12 Jun 2012 07:58:42 GMT

Thanks Jonathan, that loaded sucessfully but it didn't give what i was looking for.. see attachment.