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: 
Jesh19
Creator II
Creator II

Master Calendar for multiple event dates

Hi All,

we need to create a event calendar where i want to have a text box automatically popped up on holidays.

Like, I'm having the below table to be pulled, whenever there is a holiday i need a pop up in QV like 14/11/2018 is a holiday.

 

             EventLast Year Dates-2017       Last Year Day     This Year Dates-2018    This Year Day
New Year1/1/2017Sunday1/1/2018Monday
Easter4/16/2017Sunday4/1/2018Sunday
Labour day9/4/2017Monday9/3/2018Monday
Coloumbus day10/9/2017Monday10/8/2018Monday
Thanks giving11/23/2017Thursday11/22/2018Thursday
Black Friday11/24/2017Friday11/23/2018Friday
Christmas12/25/2017Monday12/25/2018Tuesday
Boxing day12/26/2017Tuesday                        12/26/2018Wednesday

 

Could someone please help me with the issue.

Thanking in Advance.

Regards,

Jeshwanth

2 Replies
ChennaiahNallani
Creator III
Creator III

Create a text box like with show condition in the Properties->layout->show->condition

=if(Today()=EventDate ,1,0)

in expresion 

==if(Today()=EventDate ,EventDate &' '&'is a holiday')

Jesh19
Creator II
Creator II
Author

This doesn't work.:(