topic How to show correct value in QlikView

How to show correct value

Thu, 01 Jul 2010 14:51:49 GMT

Hi guys. I came upon this problem and do not know how to solve this. Basically I have the following data:

Item	Amount	Volumes
F1111		300
F2222		200
S3333	10,000.00	500

F5555		100
F6666		400
S4444	10,000.00	500
	20,000.00	2,000.00

This is a basic setup of an invoice. We sell 2 finished products (starting with F) as one set (starting with S). The system we are using allocates a sales amount to the SET which is correct. Thus we can sum(amount) an we will get total sales. The problem comes in with Volumes. If I sum(Volumes) I get double the number of volumes sold. How can I filter this so that it only shows the volumes of the SETS.

Thanks in advance.

How to show correct value

Thu, 01 Jul 2010 14:56:09 GMT

So you want the total for F and the total for S. You are asking to sum volumes for only specific items?

Or am i getting this wrong?

How to show correct value

Thu, 01 Jul 2010 15:04:32 GMT

Yes, that is exactly what I want to do. If I sum only F I loose the amount part of S and the otherway around.

How to show correct value

Miguel_Angel_Baeyens — Thu, 01 Jul 2010 15:15:50 GMT

Hello Christo

I'd use set analysis for that, something like

Sum({< Item = {"=Left(Item, 1) = 'S'"} >} Volumes)

Hope that helps

How to show correct value

Thu, 01 Jul 2010 15:24:01 GMT

Great. It works.

Thank you for the help.