Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

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

Re: Filter table by a column value

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.
4 Replies

Re: Filter table by a column value

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.
trdandamudi
Honored Contributor II

Re: Filter table by a column value

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

Arjunarao
Honored Contributor II

Re: Filter table by a column value

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

Re: Filter table by a column value

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