topic Re: Show only names with certain values in QlikView

Show only names with certain values

Tue, 11 Nov 2014 14:55:14 GMT

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.

Re: Show only names with certain values

its_anandrjs — Tue, 11 Nov 2014 14:58:37 GMT

Hi,

In the List box expression properties write expression

If(Sport = 'Cyclist' , Persons)

like for other sport you can do

Regards

Anand

Re: Show only names with certain values

its_anandrjs — Tue, 11 Nov 2014 15:02:53 GMT

Hi,

Like this way

LOAD * Inline

[ Persons, Sport

Ralf , Cyclist

Karl , Swimmer

Peter , none

Jay , Soccer Player

Tom , Cyclist

John , Cyclist ];

Regards

Anand

Re: Show only names with certain values

marcus_malinow — Tue, 11 Nov 2014 15:04:33 GMT

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

Re: Show only names with certain values

Wed, 12 Nov 2014 10:42:41 GMT

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 !