topic Pivot table format in QlikView

Pivot table format

sankar_ganesh — Mon, 27 Oct 2014 14:31:31 GMT

Date	Product	Sales
27-Oct-14	P1	10
27-Oct-14	P1	5
28-Oct-14	P1	20
28-Oct-14	P1	30
27-Oct-14	P2	20
27-Oct-14	P2	15
28-Oct-14	P2	20
28-Oct-14	P2	40

Hello,

Above is the sample source data of my qlikview report, from which I need to create the table given below.

Here Sales is the sum(Sales) of the source data and the difference is the diff. of Sales b/w the two products. Is this possible ? Could some one give suggestions .. Thanks!

	P1	P2	Differrence
Sales	65	95	35

Regards,
Sankar

Re: Pivot table format

ajaykumar1 — Mon, 27 Oct 2014 14:48:27 GMT

Hi ,

The same format seems not possible as per my knowledge because we can arrange the Horizontally in Pivot only.

But when we arrange horizontally we will not get the exact data o/p you want.

In straight we will get the o/p but not in horizontal way.

Please correct me if am wrong.

Thanks,

Ajay

Re: Pivot table format

diwakarnahata — Mon, 27 Oct 2014 16:22:34 GMT

Hi,

See if this works for you.

Re: Pivot table format

Mon, 27 Oct 2014 16:46:04 GMT

Attached should suit requirements

Re: Pivot table format

Kushal_Chawda — Mon, 27 Oct 2014 18:07:29 GMT

May be like this

Re: Pivot table format

sankar_ganesh — Tue, 28 Oct 2014 10:21:16 GMT

It works! Thanks for all of your responses!

Cheers,
Sankar