Show only names with certain values

[#1]

Hello,

I am new to qlikview. I just connected to a table. This table has many fields. I am only interested in seeing a list box with some sort of filtered view that I can display by using expression or something else...

(for example)

Persons | Sport

Ralf | Cyclist

Karl | Swimmer

Peter | none

Jay | Soccer Player

Tom | Cyclist

John | Cyclist

What I want is a list box with just the names of the persons that do cycling for example. It should only display their names and nothing else.

Field: Persons

Ralf

Tom

John

thanks in advance for any advise.

[its_anandrjs · Accepted solution]

Hi,

In the List box expression properties write expression

If(Sport = 'Cyclist' , Persons)

like for other sport you can do

Regards

Anand

[its_anandrjs]

Hi,

Like this way

LOAD * Inline

[ Persons, Sport

Ralf , Cyclist

Karl , Swimmer

Peter , none

Jay , Soccer Player

Tom , Cyclist

John , Cyclist ];

Regards

Anand

[marcus_malinow]

Anand's approach is fine, but it may be desirable to avoid a calculated dimension. If so, I'd deal with this in the data load.

In your load script use a similar expression:

If(Sport='Cyclist', Persons, Null()) as Cyclists

[#5]

I ended up using SQL in the script which did the trick:

     SQL SELECT * from tablename

     where (People = 'Cyclist')

For my actual scenario, I really don't need to see the other values. These are NULL, blank or garbage. In this way I can filter out the data before it is displayed on my sheet.

Many thanks for the other responses, I will use them in future !