Calculate a variable

[tomhovens]

Hello Qlikviewers,

I have two variables (varPeildatum, varPlanningsbreedte) and one field (Date). By using the variables i want a selection of

greater then varPeildatum - varPlanningsbreedte - 1 and

less then varPeildatum + varPlanningsbreedte + 1

The reaction I use is:

='>='&varPeildatum-varPlanningsbreedte-1&'<='&varPeildatum+varPlanningsbreedte+1

[sunny_talwar · Accepted solution]

If you are making a selection in date field make sure the format of the date is same as your date field format

='>=' & Date(varPeildatum-varPlanningsbreedte-1, 'yourDateFormat') & '<=' & Date(varPeildatum+varPlanningsbreedte+1, 'yourDateFormat')

HTH

Best,

Sunny

[tomhovens]

Thanks for your quick answer

[sunny_talwar]

No problem! did it work for you?

Best,

Sunny

[tomhovens]

yes (Y)

[sunny_talwar]

Awesome!