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: 
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