# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
Valued Contributor III

## Number of Sundays :

Hi Experts,

I want to count the Difference 2 Dates based on Status one is Part Request and another one is Part Sent  working on Distinct TICKETNUMBER :

For eg. :

 TICKETNUMBER WORKSTATUS MODIFIEDON Sundays Coming CD1300000294778 Part Request 6/6/2013 5:53:40 PM 1 SUNDAY coming between these 2 Dates CD1300000294778 Parts Sent 6/10/2013 3:00:57 PM CD1300000294778 Part Request 6/11/2013 5:30:23 PM 1 SUNDAY coming between these 2 Dates CD1300000294778 Parts Sent 6/19/2013 3:13:57 PM CD1300000294778 Part Request 6/19/2013 4:49:45 PM 1 SUNDAY coming between these 2 Dates CD1300000294778 Parts Sent 6/27/2013 4:09:48 PM

Final Result = CD1300000294778 = 1+1+1 = 3 Sundays

Tags (1)
1 Solution

Accepted Solutions
MVP

## Re: Re: Re: Number of Sundays :

Seems to be a similar problem like the other week.

You should try to understand the priniciple solution, how you need to check for a change in TICKETNUMBER and how to cope with repeated WORKSTATUS. I assume you will need this skill more often in the near future.

I think all you need to to is to add the calculation for the number of sundays to the load where you've calculated ageing.

4 Replies

## Re: Number of Sundays :

See attached qvw

talk is cheap, supply exceeds demand
Employee

## Re: Number of Sundays :

G Wassenaar

Wow, one of the most elegant solution I have seen.

Congrats

Valued Contributor III

## Re: Re: Number of Sundays :

Sir I Appreciate your Effort. You Have a Solution for every situation. Amazing.

But when i am picking full data, it is  causing Problem.

Kindly do the Needful.

MVP

## Re: Re: Re: Number of Sundays :

Seems to be a similar problem like the other week.

You should try to understand the priniciple solution, how you need to check for a change in TICKETNUMBER and how to cope with repeated WORKSTATUS. I assume you will need this skill more often in the near future.

I think all you need to to is to add the calculation for the number of sundays to the load where you've calculated ageing.