Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Filter on value in column 1 of column 2

Guys,

I have the following dataset:

LOAD * INLINE [

    p_Player, p_Position1, p_Position2

    Luis Suarez, Mid-attack, Right-attack

    Ron Vlaar, Right-defender, Left-defender

    Piet de Vries, Right-defender, Right-mid

];

What I would like to now is to create a query that can search whether a player has a fit for position_1 OR position_2. So a list box should include all unique values of p_Position1 and p_Position2 and then based on the selection I make in the list box a straight table should show all records (players) of which the position1 or position2 = the selection in the list box.

Any thoughts on how I can accomplish this?

Tags (1)
1 Reply
Siva_Sankar
Honored Contributor

Re: Filter on value in column 1 of column 2

Marc,

Find the scrip and the file attached for example,

T1:
Load *, p_Position1 as Position
INLINE [
p_Player, p_Position1, p_Position2
Luis Suarez, Mid-attack, Right-attack
Ron Vlaar, Right-defender, Left-defender
Piet de Vries, Right-defender, Right-mid
]
;

Concatenate

Load *, p_Position2 as Position
INLINE [
p_Player, p_Position1, p_Position2
Luis Suarez, Mid-attack, Right-attack
Ron Vlaar, Right-defender, Left-defender
Piet de Vries, Right-defender, Right-mid
]
;

I am not sure whether this is your requirement. Find the qvw file.