Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
OnlyDevQlikvw
Contributor
Contributor

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

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

 

Labels (2)
3 Replies
abhijitnalekar
Specialist II
Specialist II

HI @OnlyDevQlikvw ,

You can set the order of the sorting like below.

abhijitnalekar_0-1648825124522.png

 

Hope this will help you.

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!
OnlyDevQlikvw
Contributor
Contributor
Author

Hi @abhijitnalekar , 

 

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
Specialist II
Specialist II

Yes you can.

for value, you can set it as below

abhijitnalekar_0-1648829052051.png

you will get the result as below.

abhijitnalekar_1-1648829088956.png

 

 

Regards,
Abhijit
keep Qliking...
Help users find answers! Don't forget to mark a solution that worked for you!