Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new to qlikview and Need help. I want to Check if for Example today -2 days was a Holiday (all written down in table Holiday) and then just give a Feedback. I cant even Write the if.. Thanks for the help!
It depends on what your data is structured like, but let's assume you have a calendar table, with a field called Date and field called IsHoliday (1 indicates that date is a holiday).
=sum({< Date={"$(=date(today()-2))"}, IsHoliday={1} >} 1)
if that's > 0, today - 2 = holiday.