topic Cross table in QlikView

Cross table

sankar_ganesh — Mon, 18 Aug 2014 15:24:49 GMT

Table 1:

Product	MericValue	Target
AAA	Metric1	10
AAA	Metric2	20
AAA	Metric3	30
BBB	Metric1	100
BBB	Metric2	200
BBB	Metric3	300

Table_2:

Product	Metric1	Metric2	Metric3
AAA	10	20	30
BBB	100	200	300

Hi,

I want to convert the table-1 in the table-2 format as specified above. Can anyone give your ideas ?

Thanks,

Sankar

Re: Cross table

Gysbert_Wassenaar — Mon, 18 Aug 2014 15:31:05 GMT

Yes, don't do it in the script. Use a pivot table object with Product and MetricValue as dimensions. Drag the header of MetricValue to the right above the expression so the dimension values are shown horizontally.

Re: Cross table

lft — Mon, 18 Aug 2014 15:32:10 GMT

Hi Sankar,

PFA the solution to your question

you should copy paste the pivot sub and then call :

CALL fr.qliktech.pivot('Table 1', 'Product', 'Sum', 'MetricValue', 'Target');

You could do it the other way around using the unpivot function

Loic

Re: Cross table

sankar_ganesh — Tue, 19 Aug 2014 14:53:59 GMT

Hi Loic,

Your document gives me the expected results. Thanks a lot!

Cheers,

Sankar