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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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...............