topic Crosstable? in QlikView

Crosstable?

Anonymous — Mon, 06 Jan 2014 16:40:08 GMT

Hi all,

I have this:

Customer	Product X	Product Y	Product Z
123	0	1	1
456	1	0	0
789	1	1	1

I want this?

Can you help me?

Regards,

Arjan

Gysbert_Wassenaar — Mon, 06 Jan 2014 16:46:08 GMT

Temp:

CrossTable(Product, Value)

LOAD * INLINE [

Customer, Product X, Product Y, Product Z

123, 0, 1, 1

456, 1, 0, 0

789, 1, 1, 1

];

Result:

Load Customer, replace(Product,'Product ','') as Product

Resident Temp

where Value=1;

drop table Temp;

sureshbaabu — Mon, 06 Jan 2014 16:48:04 GMT

Hello,

Please try the following:

CrossTable(Product, Data, 2)

LOAD Customer,

[Product X],

[Product Y],

[Product Z]

FROM

Data.xlsx

(ooxml, embedded labels, table is Sheet1);