topic How to use variables? in QlikView

How to use variables?

Thu, 18 Feb 2010 18:29:16 GMT

Hello, can someone point me out how to declare and use variables?

I was trying to achive something like

SET FirstDayOfTheMonth = Today();

SQL SELECT * FROM MyTable Where Date = FirstDayOfTheMonth

But Im getting an error that says "FirstDayOfTheMonth" field cannot be found.

Thank you ,

Jose.

Miguel_Angel_Baeyens — Thu, 18 Feb 2010 18:32:03 GMT

Try expanding that variable such as

SQL SELECT * FROM MyTable Where Date = $(FirstDayOfTheMonth)

That should work.

avastani — Thu, 18 Feb 2010 18:33:10 GMT

Let FirstDayOfTheMonth = Today();

SQL SELECT * FROM MyTable Where Date = '$(FirstDayOfTheMonth)';

Thu, 18 Feb 2010 19:30:17 GMT

LET is used with expressions and SET with values.