Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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.:(