topic Re: Overlapping dates in QlikView https://community.qlik.com/t5/QlikView/Overlapping-dates/m-p/1014762#M926668 <HTML><HEAD></HEAD><BODY><P>to expression Count(Country) and in dimension take the Date column</P></BODY></HTML> Wed, 30 Mar 2016 11:46:34 GMT Anonymous 2016-03-30T11:46:34Z Overlapping dates https://community.qlik.com/t5/QlikView/Overlapping-dates/m-p/1014757#M926658 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>I am working on public holidays in different countries and I need to create a chart or table showing the overlapping dates for each country. So basically I have countries and a set of public holiday dates, I need to show the dates on which the countries share a public holiday. So for example:</P><P></P><P>Country&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PublicHolidayDate</P><P>South Africa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 Apr</P><P><SPAN style="font-size: 13.3333px;">South Africa&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4 Apr</SPAN></P><P><SPAN style="font-size: 13.3333px;">Japan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 Apr</SPAN></P><P><SPAN style="font-size: 13.3333px;">Japan&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6 Apr</SPAN></P><P><SPAN style="font-size: 13.3333px;">Australia&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 Apr</SPAN></P><P><SPAN style="font-size: 13.3333px;">Australia&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30 Apr</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">(I need to thus create a chart/table showing the overlapping date (1 Apr) and count the countries that share that date)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Displaying this table:</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Number of countries&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PublicHolidayDate</SPAN></P><P><SPAN style="font-size: 13.3333px;">3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1 Apr</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4 Apr</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 6 Apr</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 13.3333px;">1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30 Apr</SPAN></P><P></P><P></P><P>Any help would be highly appreciated <IMG src="https://community.qlik.com/legacyfs/online/emoticons/blush.png" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Overlapping-dates/m-p/1014757#M926658 jeanique 2020-11-25T16:16:04Z Re: Overlapping dates https://community.qlik.com/t5/QlikView/Overlapping-dates/m-p/1014758#M926660 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119854_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Wed, 30 Mar 2016 11:28:53 GMT https://community.qlik.com/t5/QlikView/Overlapping-dates/m-p/1014758#M926660 sunny_talwar 2016-03-30T11:28:53Z Re: Overlapping dates https://community.qlik.com/t5/QlikView/Overlapping-dates/m-p/1014759#M926662 <HTML><HEAD></HEAD><BODY><P>Create the Straight Table</P><P></P><P>Dimension: <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13.3333px;">PublicHolidayDate</SPAN></P><P></P><P>Expression:</P><P>Count(Country)</P></BODY></HTML> Wed, 30 Mar 2016 11:31:39 GMT https://community.qlik.com/t5/QlikView/Overlapping-dates/m-p/1014759#M926662 Kushal_Chawda 2016-03-30T11:31:39Z Re: Overlapping dates https://community.qlik.com/t5/QlikView/Overlapping-dates/m-p/1014760#M926664 <HTML><HEAD></HEAD><BODY><P>Thanks it seemed to work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 30 Mar 2016 11:41:55 GMT https://community.qlik.com/t5/QlikView/Overlapping-dates/m-p/1014760#M926664 jeanique 2016-03-30T11:41:55Z Re: Overlapping dates https://community.qlik.com/t5/QlikView/Overlapping-dates/m-p/1014761#M926666 <HTML><HEAD></HEAD><BODY><P>to expression Count(Country) and in dimension take the Date column</P></BODY></HTML> Wed, 30 Mar 2016 11:46:28 GMT https://community.qlik.com/t5/QlikView/Overlapping-dates/m-p/1014761#M926666 Anonymous 2016-03-30T11:46:28Z Re: Overlapping dates https://community.qlik.com/t5/QlikView/Overlapping-dates/m-p/1014762#M926668 <HTML><HEAD></HEAD><BODY><P>to expression Count(Country) and in dimension take the Date column</P></BODY></HTML> Wed, 30 Mar 2016 11:46:34 GMT https://community.qlik.com/t5/QlikView/Overlapping-dates/m-p/1014762#M926668 Anonymous 2016-03-30T11:46:34Z Re: Overlapping dates https://community.qlik.com/t5/QlikView/Overlapping-dates/m-p/1014763#M926670 <HTML><HEAD></HEAD><BODY><P>Please close the thread by marking correct or helpful answer</P></BODY></HTML> Wed, 30 Mar 2016 14:27:00 GMT https://community.qlik.com/t5/QlikView/Overlapping-dates/m-p/1014763#M926670 Kushal_Chawda 2016-03-30T14:27:00Z