Field 'and' not found error

[komminenianusha]

Hi All,

I am new to qliksense while i am loading data in calendar table i have where condition like

Where
Period_Year >= $(vMinYear) and Period_Year <= $(vMaxYear) and Len(Period_Month)>1 

here i am getting error message like 'Field And not found'. Here 'and' is not a field but why i am getting this error.

See below image for error details,

Please any one help me. This is urgent.Thanks in advance.

Regards,

Anusha

[sunny_talwar · Accepted solution]

Try adding single quotes around your variable in the where statement

Where
Period_Year >= '$(vMinYear)' and Period_Year <= '$(vMaxYear)' and Len(Period_Month)>1 

[komminenianusha]

Thank you very much Stalwar . It is working now.