Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
amiroh81
Creator
Creator

Filter number of rows

Hi,

I have data from multiple sources (mainly SQL queries).

In my model I built a table with a customer name and number of instances per customer.

I would like to build a button that will filter for the user only the customers who have under-X shows.

Actually it Sounds very simple and somehow I could not actually do it.

Can anyone help?

Thanks in advance

1 Solution

Accepted Solutions
avinashelite

Create a variable like vShow and set 1 add this condition

if(vShow=1,sum({<Count={">10"}>}count), sum(Count))

View solution in original post

4 Replies
pradosh_thakur
Master II
Master II

Hi Amir

As we have not seen your data you have to be a more specific. That will help us help you better. I couldn't understand "Under x " shows part. Can you please elaborate a sample data would be a plus.

cheers

Learning never stops.
amiroh81
Creator
Creator
Author

Hi,

This is example for the data

i want the names of all costumers under 10 times 

 

John1000
Dan500
Alex400
Emma50
James10
David5
Jason 2
Chris2
Walter1
Tayler1
pradosh_thakur
Master II
Master II

Why do you need a button then ? Or you want to restrict the app to customer with count less than10 when you click that button ?

in the list box use

if(cust_count<10,customer)

Learning never stops.
avinashelite

Create a variable like vShow and set 1 add this condition

if(vShow=1,sum({<Count={">10"}>}count), sum(Count))