Sort by total

brunolelli87 — Sat, 27 Mar 2021 13:38:19 GMT

Hello guys,

How can I sort this chart by total?

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

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:

Thank you guys

topic Sort by total in QlikView