topic Re: Set Analysis in QlikView

Set Analysis

detmawin — Thu, 13 Jul 2017 10:36:57 GMT

Good day,

I am counting the number of customer returns. For example if a customer goes from Dept A to Dept B then Dept B back to Dept A, it is only considered as a single return if they do this. I have it counting the route, but it is counting twice. In the month they completed A to B

and B to A, so if they went from A to B in Jan, and B to A in Feb, it is counting 1 in Jan and 1 in Feb, it should only begin counting all events after the B to A portion is completed. so in Feb the solution should be 1 return.

Thank you.

Re: Set Analysis

Anonymous — Thu, 13 Jul 2017 10:40:49 GMT

Can you please share the sample data

Re: Set Analysis

detmawin — Thu, 13 Jul 2017 11:51:23 GMT

Thanks, I don't have an application to share but I will write this out the best way I can.

I have a list of customers

Customer A

Customer B

Customer C

Customer D

First Department

Next Department

path I am counting when customer goes from a to e and e back to a is a single return

Thanks

What I've done is is counting the first instance of the first time the customer went from a to e

and the last instance the customer went from e to a, and counted the times and divided by to, but my issue is what happens when the go from a to e in on month and e to a in another month, I only want it to count all events in the month of the completion of e to a.

so if they went fro a to e in jan

and e to a in feb I want it to count 1 in feb

thanks

Re: Set Analysis

detmawin — Thu, 13 Jul 2017 17:30:57 GMT

this has been resolved. I just shifted the calendar date.