Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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