topic Re: Where clause with 2 variables. in QlikView

Where clause with 2 variables.

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

Hi everyone!

I need to use two variables in a where clause. I try with this syntax but I did not succeed:

Let vVariable1=5;

Let vVariable2=10;

Table:

Load Field1,

Field2,

Field3

From Document

WHERE Field1 > $(vVariable1) and Field1 < $(vVariable2);

Anyone know the correct syntax for this example?

Thanks in advance!

Re: Where clause with 2 variables.

vishsaggi — Fri, 02 Feb 2018 17:20:09 GMT

Try this

Let vVariable1=5;

Let vVariable2=10;

Table:

Load Field1,

Field2,

Field3

From Document

WHERE Field1 > '$(vVariable1)' and Field1 < '$(vVariable2)';

Re: Where clause with 2 variables.

kikerodriguez10 — Fri, 02 Feb 2018 17:30:47 GMT

Thanks for your help @Vishwarath Nagaraju !

I tried it but did not work, also I tried with double quote but neither work.

Any other syntax?

Thank you very much!

Re: Where clause with 2 variables.

devarasu07 — Fri, 02 Feb 2018 17:35:52 GMT

Hi,

Seems like some data format issue . can you share some mock data and expected output. that would be easy for us to check and share our suggestions. Thanks

Thanks,
Deva

Re: Where clause with 2 variables.

vishsaggi — Fri, 02 Feb 2018 18:22:32 GMT

What are the values you hold in your Field1 column? Can you share some sample data to look into. ?

Re: Where clause with 2 variables.

Clever_Anjos — Mon, 05 Feb 2018 14:45:05 GMT

It seems correct to me, unless Field1 has a different format