Discussion board where members can get started with QlikView.
I need to use two variables in a where clause. I try with this syntax but I did not succeed:
WHERE Field1 > $(vVariable1) and Field1 < $(vVariable2);
Anyone know the correct syntax for this example?
Thanks in advance!
WHERE Field1 > '$(vVariable1)' and Field1 < '$(vVariable2)';
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!
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
What are the values you hold in your Field1 column? Can you share some sample data to look into. ?
It seems correct to me, unless Field1 has a different format