Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
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))

View solution in original post