Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jeshwanth19
Contributor 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
Highlighted
ChennaiahNallani
Contributor III

Re: Master Calendar for multiple event dates

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')

jeshwanth19
Contributor II

Re: Master Calendar for multiple event dates

This doesn't work.:(