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: 
Not applicable

Filter table by a column value

I have a table object in QlikView which has many rows and columns. I am trying to filter (display only) rows that have a string column set to a concret value but without success.

For example, from below table.

Name         Gender      Age 

John           Male         34

Marie          Female     28

Clarie          Female     40

Paul            Male        60

David          Male        45

I only want to display in table those rows which Gender column is Female. The result would be:

Name         Gender      Age

Marie          Female     28

Clarie          Female     40

How can I do this?

1 Solution

Accepted Solutions
PrashantSangle

Load * from table where Gender='Female'

or take straight table instead of Table box and

expression Only({<Gender={'Female'}>}Age)

dimension Name and Gender

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

4 Replies
PrashantSangle

Load * from table where Gender='Female'

or take straight table instead of Table box and

expression Only({<Gender={'Female'}>}Age)

dimension Name and Gender

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
trdandamudi
Master II
Master II

In a straight chart you can use either of the below expressions:

MaxString( {<Gender={'Female'}>}Gender)

OR

Only( {<Gender={'Female'}>}Gender)

Show_Based_On_Filter.jpg

qlikviewwizard
Master II
Master II

Data:

Load * Inline [

Name,Gender,Age

John ,Male,34

Marie,Female,28

Clarie,Female ,40

Paul,Male,60

David,Male,45

]

where WildMatch(Gender,'Female');

Not applicable
Author

Thanks for your example. Your answer is also correct but I have put as correct that from max dreamer as he answered first.