topic Re: Filter table by a column value in QlikView

Filter table by a column value

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Filter table by a column value

PrashantSangle — Mon, 18 Jul 2016 11:18:51 GMT

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

Re: Filter table by a column value

trdandamudi — Mon, 18 Jul 2016 11:35:17 GMT

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

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

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

Re: Filter table by a column value

qlikviewwizard — Mon, 18 Jul 2016 12:13:33 GMT

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

Re: Filter table by a column value

Tue, 19 Jul 2016 10:04:42 GMT

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