Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
In the List box expression properties write expression
If(Sport = 'Cyclist' , Persons)
like for other sport you can do
Regards
Anand
Hi,
In the List box expression properties write expression
If(Sport = 'Cyclist' , Persons)
like for other sport you can do
Regards
Anand
Hi,
Like this way
LOAD * Inline
[ Persons, Sport
Ralf , Cyclist
Karl , Swimmer
Peter , none
Jay , Soccer Player
Tom , Cyclist
John , Cyclist ];
Regards
Anand
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
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 !