Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist III

Organization Name of Engineer Wise Holiday Count

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)

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.

Tags (1)
1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Re: Organization Name of Engineer Wise Holiday Count

See attached qvw


talk is cheap, supply exceeds demand

View solution in original post

2 Replies
Highlighted
MVP & Luminary
MVP & Luminary

Re: Organization Name of Engineer Wise Holiday Count

See attached qvw


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Specialist III
Specialist III

Re: Organization Name of Engineer Wise Holiday Count

Perfect Sir. Thank You very much.