text box

[niranjana]

Hi

How to display top 5 countries with least sales in Qliksense Text Box?

Also , how to display States/Countries in qliksense text box which have Zero sales?

Thanks in advance

[Qlik1_User1]

@niranjana 

Use Firstsortedvalue() and AGGR() together it will solve the need.

[niranjana]

Can you pls provide the expression for both scenarios?

Thanks