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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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