one small query.. one giant leap for my project.

[#1]

Morning all,

I have completed around 90% of my first qlikview project.. I say "I" its been about 3 posts on here and lots of help from a colleague but non the less its at about 90%.

I have one final task to do before it is ready for customer testing.

My example data set might be...

Date	Job	Calls	Abn	Abn %
26 Feb 09	1	781	67	9%
02 Mar 09	2	210	27	13%
04 Mar 09	3	990	33	3%
11 Mar 09	4	997	22	2%
16 Mar 09	5	652	31	5%
16 Mar 09	6	432	28	6%

What I would like to do is filter this data to only show me the highest abandoning job per week. For example in this table the highest job for W/C 01 Mar 09 is Job 2. For W/C 15 Mar 09 it is Job 5.

I dont currently have a W/C field but if that would make it easier to calculate it can be added very easily.

[#2]

Hi,

Sorry for the question, but what do you call W/C ?

Sébastien

[#3]

W/C = Week Commecing. I also define my first day of the week as a Sunday.

[#4]

To get your first day of the week, beginning on Sunday you can use function Weekstart:

weekstart (Date,0,-1) ( -1 is here to tell system to begin on sunday).

[#5]

Thanks,

That should hopefully help when i come to trying to filter it down to show me the top abandoning job per week.

[prieper]

Please see the attached, which tries to solve your problem within the script.

Peter

[#7]

Thanks Peter,

Technically that is correct and exactly what I am after however I should have explained my data correctly.

the table I sent was an example of how my data is looking at the moment. In actual fact my source data is split down to individual call level then summed by job number.

My raw data actually looks something like this.. I am calculating where we make a connection but then the call is abandoned.

Job	Fake Key	Job Date	Call Time	Connect	Abandoned
1	213863	16-Mar-09	08:30:31	1	0
1	590473	16-Mar-09	08:32:56	1	0
1	432519	16-Mar-09	09:57:02	1	1
1	764506	16-Mar-09	10:46:55	1	0
1	508996	16-Mar-09	11:40:22	1	0
1	347070	16-Mar-09	13:11:15	1	0
1	372819	16-Mar-09	13:48:57	1	0
1	351588	16-Mar-09	13:55:52	1	0
1	637888	16-Mar-09	14:39:10	1	1
2	788929	16-Mar-09	09:35:31	1	0
2	969255	16-Mar-09	09:48:16	1	1
2	750642	16-Mar-09	10:50:31	1	0
2	248329	16-Mar-09	12:07:18	1	0
2	837395	16-Mar-09	12:18:45	1	0
2	853853	16-Mar-09	12:30:49	1	0
2	481674	16-Mar-09	13:40:11	1	0