Need help

[liziegarb]

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!

[stevejoyce]

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.

[Maria_Halley]

@liziegarb

I will move this post to the QlikView App Dev thread.