Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Filterable List Box

Hello,

I have a strait table and i want to make the values within columns filterable.  For instance, if a select a value then the whole table filters on that particular value.  How is this achieved??  I do not want to have a list box for this.

Thank you.

Tags (3)
13 Replies
Highlighted
MVP
MVP

Re: Filterable List Box

Can you elaborate little more please? if possible, please give one small example

Not applicable

Re: Filterable List Box

Hi,

Use set analysis for current selection.write the set analysis in straight table whatever you want filter condition

Not applicable

Re: Filterable List Box

Yes.  Lets say that my table looks like this:

Geography          Name     Sales

Texas               John          24

Texas               Jim          18    

New Mexico     Jen          20

Arizona              Jerry     18

and so I select 'Texas', then i see

Geography          Name     Sales

Texas               John          24

Texas               Jim          18    

Not applicable

Re: Filterable List Box

come up with little bit clear

MVP
MVP

Re: Filterable List Box

Of cource, you will get only Texas data once you select Texas... What is your question?

Not applicable

Re: Filterable List Box

So my issue is that if i Select Texas, then I am only getting one row returned and not all of the Texas rows

Not applicable

Re: Filterable List Box

Hi,


If you slect texas by default it will give output how you need.tell me wats your exact requirement

Not applicable

Re: Filterable List Box

So my issue is that when i select Texas, I am just getting back one row of Teas....not all of the Texas values, which is what I want

MVP
MVP

Re: Filterable List Box

Provide your table dimension and expressions...

Community Browser