topic Re: Counting repeat/returned units in QlikView

Counting repeat/returned units

Anonymous — Wed, 26 Aug 2015 10:03:38 GMT

Hi all,

I apologise if this is very vague however I don't really know where to start!

I'm trying to count/flag units that have been sold by any company and then returned to us and sold again by our company. As we don't record returned units to our company this has made the task much harder.

The aim is to show a percentage each month of returned units.

I really have no idea where to go with this but it is a very important piece of analysis.

Once again I apologise for the vagueness!

Thanks

Gareth

Re: Counting repeat/returned units

tresB — Wed, 26 Aug 2015 10:08:19 GMT

Let's start with what you have rather than what you don't have. Let us know the facts your company records while selling or buying.

Re: Counting repeat/returned units

Anonymous — Wed, 26 Aug 2015 10:17:36 GMT

Thanks tresesco any help will be greatly appreciated.

We record,

sold.date

sold.month

unit.id

unit.vendor

unit.buyer

m.id_no (this is a unique number that is generated everytime the unit is sold)

these are the only fields that I think are relevant other fields we have are colour, price, type which I don't believe would help.

I was looking at using the unit.id as the dimension and the expression as match(unit.vendor, 'vendor1','vendorourcompany') but this would just show units that have been sold at some point by a vendor and our company which isn't what I am trying to achieve. Maybe doing something with match( but adding in if it has been sold by a vendor and then one month later sold by our company, this would then show the correct units.

Re: Counting repeat/returned units

tresB — Wed, 26 Aug 2015 11:35:50 GMT

Sorry, not really clear. Could you give an example of transactions and explain?

Re: Counting repeat/returned units

jonathandienst — Wed, 26 Aug 2015 12:14:56 GMT

If a returned item is resold , is there any field that can link the two sales, like unit.id?