Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Contributor II

where statement with two criterias


I would like to load some fields between two dates and I am not sure, if the where statement is correct.


Can somebody please support?


Resident Calc_AUX where [Calc.month code] >=$(vL.month_min3) <=$(vL.month_completed);

Or do I need to add a "and": Resident Calc_AUX where [Calc.month code] >=$(vL.month_min3) and [Calc.month code]<=$(vL.month_completed);

1 Reply

Re: where statement with two criterias

Second statement is valid. You can use this?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)