Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!