Pivot table split up

james_hanify — Mon, 18 Jul 2016 16:13:40 GMT

Hi,

I don't know whether this is possible but this is what I would like to achieve.

Format / Example Data of how I would like it to look like is:

Customer	Customer Name	Sector	Years with company	Number of orders				Revenue
				Services	Product	Both	Total	Services	Product	Total
1	A	ZZ	1	2	2	2	6	100	200	300
2	B	YY	2	1	1	1	3	50	200	250
3	C	ZZ	3	2	1	1	4	70	90	160

The best i've been able to do is based on the attachment, using an if statement to create the difference between a product and a service, as the if statement to count the revenue didn't seem to work when I removed that dimension, it would just assigned it to the first one.

I'm also unsure about the product and services on how to do this as the data structure is

Order

Order number (o1234)

Order Details

Order Number, Item (x1234)

ItemDetails

Item, Item Name, Product Type (apple)

I have then been doing an if statement to say if product type = service, its a service, if it isn't its a product.

Hopefully you can provide some input even if I am being a bit vague.

Many thanks,

james

Re: Pivot table split up

settu_periasamy — Mon, 18 Jul 2016 18:45:10 GMT

Hi James,

sorry for not getting. which one is your base data, and how do you want to show the data?

Re: Pivot table split up

james_hanify — Tue, 19 Jul 2016 08:23:41 GMT

Ah sorry my base data (updated the original post too) format in its basic form

Order

Order number (o1234)

Order Details

Order Number, Item (x1234)

ItemDetails

Item, Item Name, Product Type (apple)

How I want to show it is the table.

topic Re: Pivot table split up in QlikView

Pivot table split up

Re: Pivot table split up

Re: Pivot table split up