Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
Thanks for your quick answer
No problem! did it work for you?
Best,
Sunny
yes (Y)
Awesome!