topic Re: How to use variable in the where clause ? in QlikView

How to use variable in the where clause ?

nishanthi_8 — Wed, 25 Nov 2020 16:16:04 GMT

I need to restrict the table loading by giving some condition in the where clause. And I need to store the possible values in the variable

For example :

LET Var='Chairs,tables';

LOAD

----

------

--------

WHERE (Products='$(Var)');

But i encounter some error in this. Is there any possible way to do this. I need to store the possible values in the variable

Re: How to use variable in the where clause ?

Thu, 17 Nov 2016 05:40:55 GMT

Hi,

you can use this

LOAD

---

WHERE MIXMATCH(Products, $(Var) );

Re: How to use variable in the where clause ?

nishanthi_8 — Thu, 17 Nov 2016 05:43:36 GMT

No nothing is fetched up. The comma and the quotes separation in variable is the thing to be taken care of. I need help in that

Re: How to use variable in the where clause ?

Anil_Babu_Samineni — Thu, 17 Nov 2016 05:43:45 GMT

You can change variable like below

SET Var='Chairs,tables';

Please read this !!!

SET vs. LET

I got into a conversation with someone today who was struggling to understand the difference between SET and LET. It wasn't the first time I've had this conversation so thought I'd explain it here too in case any QV newbies were also struggling with it.

SET is taken literally and what is on the right of the equals is written into the variable. So writing:

SET vMyVariable = 5*2;

Would result in vMyVariable containing "5*2".

LET is used when you wish QlikView to equate what is on the right of the equals and write the answer into the variable. So writing:

LET vMyVariable = 5*2;

Would result in vMyVariable containing "10".

Simples!

Re: How to use variable in the where clause ?

Anonymous — Thu, 17 Nov 2016 06:01:31 GMT

Why do you need a variable to filter the table?

Can you not use an inline load? i.e

See sample below...If you use this, the filter field Products must not be loaded prior to using this...

The filter text (Tables, Chairs) must be exact match as in your table/Case sensitive.

Filter:
LOAD * INLINE [
Products
Tables

Chairs

];

YourTable:

LOAD *
FROM
YourSource...
where Exists(Products);

Re: How to use variable in the where clause ?

tamilarasu — Thu, 17 Nov 2016 06:03:21 GMT

Hi Nishanthi,

Try something like below

SET Var= 'Chairs' , 'tables' ;

LOAD

----

------

--------

WHERE WildMatch(Products, $(Var) );