Discussion Board for collaboration on QlikView Scripting.
For every "TICKET NUMBER" there comes one "CREATION DATE" and "ENGINEER COMPLETED DATE".
I want to Calculate the Holidays Count falling between these 2 Dates for unique TICKET NUMBERS.
EXAMPLE : FOR AUGUST MONTH :
ORGANIZATION NAME OF ENGINEER :
1) LEVEL IV DELHI = 4 Holidays (09/08/13,15/08/13,20/08/13,28/08/13)
2) ASF PATNA = 2 Holidays (09/08/13,15/08/13)
3 ASF BHUBANESHWAR = 2 Holidays (09/08/13,15/08/13)
If HOLIDAY Dates falling between the Unique "TICKET NUMBER"
"CREATION DATE" and "ENGINEER COMPLETED DATE" then Show its Holiday Count.
See attached qvw
View solution in original post
Perfect Sir. Thank You very much.