Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
SR2
Contributor III
Contributor III

Top 10 Invoices by condition

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!

Labels (1)
1 Solution

Accepted Solutions
Dalton_Ruer
Employee
Employee

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. 

Top10.png

View solution in original post

2 Replies
Dalton_Ruer
Employee
Employee

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. 

Top10.png

View solution in original post

SR2
Contributor III
Contributor III
Author

Hello Dalton,

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

 

Best regards,