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

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
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
Employee

Re: Number of Sundays :

G Wassenaar

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

Congrats

aveeeeeee7en
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
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.

Community Browser