Top 10 Invoices by condition

[SR2]

Hello Experts,

I want to create a simple table to show Top10 invoices based on following condition - 

1) If the Dim ([Hold flag]) =1

2) If payment date > today

Arrange list of invoices in descending order of invoice amount.

I am unable to figure out how to show only invoices with [hold flag] = 1 in table without using filters. 

Thank you!

[Dalton_Ruer · Accepted solution]

Oooooooooh I love the fact that you already have your flag. You are ready to blast off on some serious performance. 

You can simply MULTIPLY your flag by the "Invoice Amount".   

[Hold Flag] * [Invoice Amount]

If the flag is 1 then you will get the Invoice Amount

If the flag is 0 then you will get 0

So if you sort the chart based on the Invoice Amount in descending order, your problem is solved. Gotta love flags in Qlik Sense. Simply change the Limitation from none to Fixed Value and set the value to 10. 

[SR2]

Hello Dalton,

Sorry for my delay in coming back. Thank you Dalton. The solution works for me. 

Best regards,