Hello guys,
How can I sort this chart by total?
![brunolelli87_0-1616851663061.png brunolelli87_0-1616851663061.png](https://community.qlik.com/t5/image/serverpage/image-id/51940i1967556256716B8E/image-size/medium?v=v2&px=400)
As you can see, I've created an expression to try, but it's not working...
![brunolelli87_1-1616851712450.png brunolelli87_1-1616851712450.png](https://community.qlik.com/t5/image/serverpage/image-id/51941i9C46B6ABA760CACF/image-size/medium?v=v2&px=400)
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 brunolelli87_2-1616851980561.png](https://community.qlik.com/t5/image/serverpage/image-id/51942i5382381EFD9E2F53/image-size/medium?v=v2&px=400)
Thank you guys