topic Re: Using Variable in Where Statement in QlikView

Using Variable in Where Statement

markgraham123 — Wed, 27 Jan 2016 19:20:35 GMT

Hello Everyone,

I'm trying to use Variable in Where statement which has multiple values.

Can someone pls look into this.

Re: Using Variable in Where Statement

sunny_talwar — Wed, 27 Jan 2016 19:23:18 GMT

Try these modifications:

Table:

LOAD * INLINE [

FieldA

];

// Create a temporary table

tmp:

NoConcatenate

Load concat(Distinct FieldA,',') as FieldA

Resident Table;

let vVar1 = peek('FieldA',0,'tmp');

// drop the temporary table

drop table tmp;

Table2:

LOAD * INLINE [

FieldB

];

NoConcatenate

LOAD * Resident Table2

Where

Match(FieldB, $(vVar1));

DROP Table Table, Table2;

Re: Using Variable in Where Statement

Gysbert_Wassenaar — Wed, 27 Jan 2016 19:25:38 GMT

Try Where match(FieldB,$(vVar1));

Re: Using Variable in Where Statement

maxgro — Wed, 27 Jan 2016 19:26:43 GMT

Table:

LOAD * INLINE [

FieldA

];

// Create a temporary table

tmp:

NoConcatenate

Load concat(Distinct FieldA,',') as FieldA

Resident Table;

let vVar1 = peek('FieldA',0,'tmp');

// drop the temporary table

drop table tmp;

Table2:

LOAD * INLINE [

FieldB

];

Table3:

NoConcatenate LOAD * Resident Table2

Where

match(FieldB, $(vVar1));

DROP Table Table2;

Re: Using Variable in Where Statement

markgraham123 — Wed, 27 Jan 2016 22:23:58 GMT

Thanks a lot Sunny!

Re: Using Variable in Where Statement

markgraham123 — Wed, 27 Jan 2016 22:24:32 GMT

Thanks Gysbert

It worked.

Re: Using Variable in Where Statement

markgraham123 — Wed, 27 Jan 2016 22:25:08 GMT

Thanks M G.