Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Calendar Issue

Create a calendar in QlikView and a mapping in such a way that if user selects a day, it shows whether it was a holiday\weekend or not.

1 Solution

Accepted Solutions
Not applicable
Author

you could create an Excel file for your calendar with the fields:

  • date
  • date as %key

And create another Excel for your holidays and week and with the field :

  • holiday_day as %key



View solution in original post

2 Replies
Not applicable
Author

you could create an Excel file for your calendar with the fields:

  • date
  • date as %key

And create another Excel for your holidays and week and with the field :

  • holiday_day as %key



Anonymous
Not applicable
Author

Hi Anthony

Ur answer is write but I want it by using script like using IF statement

like if ordererdate is "28/01/2011" then display today is holiday in text box