Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

amiroh81
New Contributor

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

Re: Filter number of rows

Create a variable like vShow and set 1 add this condition

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

4 Replies
pradosh_thakur
Valued Contributor III

Re: Filter number of rows

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

amiroh81
New Contributor

Re: Filter number of rows

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
Valued Contributor III

Re: Filter number of rows

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)

Re: Filter number of rows

Create a variable like vShow and set 1 add this condition

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

Community Browser