Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
aveeeeeee7en
Valued Contributor 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

Re: Organization Name of Engineer Wise Holiday Count

See attached qvw


talk is cheap, supply exceeds demand
2 Replies

Re: Organization Name of Engineer Wise Holiday Count

See attached qvw


talk is cheap, supply exceeds demand
aveeeeeee7en
Valued Contributor III

Re: Organization Name of Engineer Wise Holiday Count

Perfect Sir. Thank You very much.

Community Browser