topic Sorting using multiple fields in QlikView

Sorting using multiple fields

Mon, 08 Aug 2011 15:41:23 GMT

I need to sort a table with one dimension by mutilpe fields. I am displaying Saleman but need it in the following order. First sort by the field that identifies "Domestic" vs "Export" - the field is DE and is either a 1 or a 2. Second, I need to sort the dimension by Regeion - field REG and numbers from 1 to 6. Third, I need to sort by Salesman number.

How can I do this?

Thanks,

Stephen

Sorting using multiple fields

SunilChauhan — Mon, 08 Aug 2011 15:44:14 GMT

use interactive sort

so that if u click on top of the field or expression it will sort according to that field.

take straight table and go sort check on interactive

in pivot it is availale automatically please check

Sorting using multiple fields

its_anandrjs — Mon, 08 Aug 2011 15:46:12 GMT

Hi sjcharles,

You need to create a straight table or just go to sort section and there set the dimensions sort order of the dimensins.

Hope this helps you.

Regards,

Anand

Sorting using multiple fields

Mon, 08 Aug 2011 15:59:16 GMT

In pivot table it is automatic only if I am displaying all of the fields. I am only displaying the Saleman field, but it need to sort by three other field and in a specific order.

Sorting using multiple fields

its_anandrjs — Mon, 08 Aug 2011 16:05:19 GMT

Hi sjcharles,

Use Straight table not pivot table then go to sort options and apply sorting criteria.In pivot it sort in single values only.

Regards,

Anand

Sorting using multiple fields

SunilChauhan — Mon, 08 Aug 2011 16:06:51 GMT

at a time you can not sort on the basis of more than one field

but you can sort one by one by click on top of fields

Sorting using multiple fields

Mon, 08 Aug 2011 17:33:31 GMT

Looks like I will need to create a composite sort field.

Stephen