topic Re: [QLIKVIEW] How to sort by asc value AND by category ? in QlikView

[QLIKVIEW] How to sort by asc value AND by category ?

OnlyDevQlikvw — Fri, 01 Apr 2022 13:54:31 GMT

Hello,

I have a chart with this data :

Category Value

A 12

A 15

A 11

B 16

B 9

and I want to have :

A 11

A 12

A 15

B 9

B 16

Can someone help me ?

Thx

abhijitnalekar — Fri, 01 Apr 2022 14:59:17 GMT

You can set the order of the sorting like below.

Hope this will help you.

OnlyDevQlikvw — Fri, 01 Apr 2022 15:22:36 GMT

Thanks for you reply. But I also need to sort on the value by category.

I mean alphabetic sort on the field 'CATEGORY' and a sort asc on the field 'VALUE'

Is it possible ?

Thx

abhijitnalekar — Fri, 01 Apr 2022 16:04:54 GMT

Yes you can.

for value, you can set it as below

you will get the result as below.