topic Need Help..? in QlikView https://community.qlik.com/t5/QlikView/Need-Help/m-p/573670#M1110934 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P>PFA,</P><P></P><P>Table:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Token Num, OrderDate, Invoice Date</P><P>&nbsp;&nbsp;&nbsp; 100, 1/1/2014, 1/5/2014</P><P>&nbsp;&nbsp;&nbsp; 101, 1/9/2014, 1/15/2014</P><P>&nbsp;&nbsp;&nbsp; 102, 1/13/2014, 1/23/2014</P><P>&nbsp;&nbsp;&nbsp; 103, 1/22/2014, 1/31/2014</P><P>&nbsp;&nbsp;&nbsp; 104, 1/25/2014, 2/5/2014</P><P>&nbsp;&nbsp;&nbsp; 105, 2/6/2014, 2/10/2014</P><P>&nbsp;&nbsp;&nbsp; 106, 2/12/2014, 2/14/2014</P><P>&nbsp;&nbsp;&nbsp; 107, 2/15/2014, 2/22/2014</P><P>&nbsp;&nbsp;&nbsp; 108, 2/23/2014, 2/27/2014</P><P>&nbsp;&nbsp;&nbsp; 109, 3/1/2014, 3/5/2014</P><P>&nbsp;&nbsp;&nbsp; 110, 3/10/2014, 3/15/2014</P><P>&nbsp;&nbsp;&nbsp; 110, 3/10/2014, 3/15/2014</P><P>];</P><P>Holiday List:</P><P>Load * Inline</P><P>[Date, Holiday List</P><P>7/1/2014, Guru Govind Singh Jayanti</P><P>14/1/2014, Pongal</P><P>26/1/2014, Republic Day</P><P>31/1/2014, Chinese New Year];</P><P></P><P></P><P>Here calculating Sunday also...</P><P></P><P></P><P>Example:</P><P>OrderDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; InvoiceDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Count_of_Holidays</P><P>1/1/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/8/2014&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; 3&nbsp;&nbsp; (1 sat, 1 sun and 1 holiday total=3)</P><P>1/27/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2/1/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; (1 holiday)</P><P></P><P></P><P>Hope you Understand................</P><P></P><P></P><P>Thanks in Advance...........</P></BODY></HTML> Wed, 26 Feb 2014 17:05:00 GMT 2014-02-26T17:05:00Z Need Help..? https://community.qlik.com/t5/QlikView/Need-Help/m-p/573670#M1110934 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P>PFA,</P><P></P><P>Table:</P><P>LOAD * INLINE [</P><P>&nbsp;&nbsp;&nbsp; Token Num, OrderDate, Invoice Date</P><P>&nbsp;&nbsp;&nbsp; 100, 1/1/2014, 1/5/2014</P><P>&nbsp;&nbsp;&nbsp; 101, 1/9/2014, 1/15/2014</P><P>&nbsp;&nbsp;&nbsp; 102, 1/13/2014, 1/23/2014</P><P>&nbsp;&nbsp;&nbsp; 103, 1/22/2014, 1/31/2014</P><P>&nbsp;&nbsp;&nbsp; 104, 1/25/2014, 2/5/2014</P><P>&nbsp;&nbsp;&nbsp; 105, 2/6/2014, 2/10/2014</P><P>&nbsp;&nbsp;&nbsp; 106, 2/12/2014, 2/14/2014</P><P>&nbsp;&nbsp;&nbsp; 107, 2/15/2014, 2/22/2014</P><P>&nbsp;&nbsp;&nbsp; 108, 2/23/2014, 2/27/2014</P><P>&nbsp;&nbsp;&nbsp; 109, 3/1/2014, 3/5/2014</P><P>&nbsp;&nbsp;&nbsp; 110, 3/10/2014, 3/15/2014</P><P>&nbsp;&nbsp;&nbsp; 110, 3/10/2014, 3/15/2014</P><P>];</P><P>Holiday List:</P><P>Load * Inline</P><P>[Date, Holiday List</P><P>7/1/2014, Guru Govind Singh Jayanti</P><P>14/1/2014, Pongal</P><P>26/1/2014, Republic Day</P><P>31/1/2014, Chinese New Year];</P><P></P><P></P><P>Here calculating Sunday also...</P><P></P><P></P><P>Example:</P><P>OrderDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; InvoiceDate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Count_of_Holidays</P><P>1/1/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1/8/2014&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; 3&nbsp;&nbsp; (1 sat, 1 sun and 1 holiday total=3)</P><P>1/27/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2/1/2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp; (1 holiday)</P><P></P><P></P><P>Hope you Understand................</P><P></P><P></P><P>Thanks in Advance...........</P></BODY></HTML> Wed, 26 Feb 2014 17:05:00 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/573670#M1110934 2014-02-26T17:05:00Z Re: Need Help..? https://community.qlik.com/t5/QlikView/Need-Help/m-p/573671#M1110935 <HTML><HEAD></HEAD><BODY><P>Please check</P></BODY></HTML> Wed, 26 Feb 2014 17:15:11 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/573671#M1110935 Clever_Anjos 2014-02-26T17:15:11Z Re: Need Help..? https://community.qlik.com/t5/QlikView/Need-Help/m-p/573672#M1110936 <HTML><HEAD></HEAD><BODY><P>Hi Clever,</P><P></P><P>But here not all Saturday's&nbsp;&nbsp; <STRONG>(1st and 3rd Saturday's holiday</STRONG> and<STRONG> 2nd, 4th and 5th Sat's working days )</STRONG></P><P>please can you write scripting level............</P></BODY></HTML> Wed, 26 Feb 2014 17:21:24 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/573672#M1110936 2014-02-26T17:21:24Z Re: Re: Need Help..? https://community.qlik.com/t5/QlikView/Need-Help/m-p/573673#M1110937 <HTML><HEAD></HEAD><BODY><P>Like This ?</P></BODY></HTML> Wed, 26 Feb 2014 17:29:40 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/573673#M1110937 MK_QSL 2014-02-26T17:29:40Z Re: Re: Need Help..? https://community.qlik.com/t5/QlikView/Need-Help/m-p/573674#M1110938 <HTML><HEAD></HEAD><BODY><P>PFA</P></BODY></HTML> Wed, 26 Feb 2014 17:31:29 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/573674#M1110938 Clever_Anjos 2014-02-26T17:31:29Z Re: Re: Re: Need Help..? https://community.qlik.com/t5/QlikView/Need-Help/m-p/573675#M1110939 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thanks for Helping..</P><P></P><P>I got it...............</P></BODY></HTML> Wed, 26 Feb 2014 19:10:35 GMT https://community.qlik.com/t5/QlikView/Need-Help/m-p/573675#M1110939 2014-02-26T19:10:35Z