topic Re: Top 10 Invoices by condition in App Development

Top 10 Invoices by condition

SR2 — Sat, 16 Nov 2024 00:17:50 GMT

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!

Re: Top 10 Invoices by condition

Dalton_Ruer — Wed, 07 Apr 2021 13:36:20 GMT

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.

Re: Top 10 Invoices by condition

SR2 — Thu, 15 Apr 2021 08:35:10 GMT

Hello Dalton,

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

Best regards,