topic Re: cross table in QlikView

cross table

tincholiver — Sat, 25 Sep 2021 14:45:02 GMT

hi everyone,

I don´t know how solve this:

mi table:

DATE	CAR	Quant
202107	AUDI	4
202107	HONDA	9
202107	FORD	129
202108	AUDI	3
202108	HONDA	7
202108	FORD	116

mi desired table:

DATE	AUDI	HONDA	FORD
202107	4	8	129
202108	3	7	119

ideas? thank a lot

Re: cross table

AshutoshBhumkar — Sat, 25 Sep 2021 15:25:36 GMT

Hi,

You'll have to use separate measure for each CAR in straight table.

Measure for AUDI : Sum({<CAR = {"AUDI"}>}Quant)

and 2 more for other Cars.

Or you can use Pivot table :

Thanks,

Ashutosh

Re: cross table

tincholiver — Sat, 25 Sep 2021 16:37:36 GMT

hi @AshutoshBhumkar

i need to load desired table in script not in graph

Re: cross table

Saravanan_Desingh — Sat, 25 Sep 2021 18:16:11 GMT

Try this,

tab1: Generic LOAD * INLINE [ DATE, CAR, Quant 202107, AUDI, 4 202107, HONDA, 9 202107, FORD, 129 202108, AUDI, 3 202108, HONDA, 7 202108, FORD, 116 ];

Re: cross table

tincholiver — Sat, 25 Sep 2021 21:04:44 GMT

thanks @Saravanan_Desingh

works perfect!!