Filter table by a column value

[#1]

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?

[PrashantSangle · Accepted solution]

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

[trdandamudi]

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

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

OR

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

[qlikviewwizard]

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');

[#5]

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