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: 
brunolelli87
Creator II
Creator II

Sort by total

Hello guys,

 

How can I sort this chart by total?

brunolelli87_0-1616851663061.png

 

As you can see, I've created an expression to try, but it's not working...

brunolelli87_1-1616851712450.png

The expression I'm using to sort is:

 

=count( {<DATA ={'$(vData3)'},ONGR={'0'}>}  DISTINCT NVOO)

 

 

My chart dimension is:

 

=ORIG&' - '&DEST

 

 

And I have three expressions, each one about an specific airline e.g(NCIA={'AZU'}):

 

=count({<DATA ={'$(vData3)'},NCIA={'AZU'},ONGR={'0'}>} DISTINCT NVOO)

 

  

I would like to have something like this:

brunolelli87_2-1616851980561.png

 

Thank you guys

0 Replies