Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need Help..?

Hi Experts,

PFA,

Table:

LOAD * INLINE [

    Token Num, OrderDate, Invoice Date

    100, 1/1/2014, 1/5/2014

    101, 1/9/2014, 1/15/2014

    102, 1/13/2014, 1/23/2014

    103, 1/22/2014, 1/31/2014

    104, 1/25/2014, 2/5/2014

    105, 2/6/2014, 2/10/2014

    106, 2/12/2014, 2/14/2014

    107, 2/15/2014, 2/22/2014

    108, 2/23/2014, 2/27/2014

    109, 3/1/2014, 3/5/2014

    110, 3/10/2014, 3/15/2014

    110, 3/10/2014, 3/15/2014

];

Holiday List:

Load * Inline

[Date, Holiday List

7/1/2014, Guru Govind Singh Jayanti

14/1/2014, Pongal

26/1/2014, Republic Day

31/1/2014, Chinese New Year];

Here calculating Sunday also...

Example:

OrderDate           InvoiceDate         Count_of_Holidays

1/1/2014               1/8/2014                           3   (1 sat, 1 sun and 1 holiday total=3)

1/27/2014               2/1/2014                        1  (1 holiday)

Hope you Understand................

Thanks in Advance...........

5 Replies
Clever_Anjos
Employee
Employee

Please check

Not applicable
Author

Hi Clever,

But here not all Saturday's   (1st and 3rd Saturday's holiday and 2nd, 4th and 5th Sat's working days )

please can you write scripting level............

MK_QSL
MVP
MVP

Like This ?

Clever_Anjos
Employee
Employee

PFA

Not applicable
Author

Hi,

Thanks for Helping..

I got it...............