topic Re: Column to row in Connectivity & Data Prep

Column to row

Shirazc123 — Thu, 10 Aug 2023 11:21:22 GMT

Hi!

I need to get from option 1 to option 2.

how can I do that?

Thanks!

JHuis — Thu, 10 Aug 2023 12:08:06 GMT

Yes,

you have to use the Crosstab function (inside qliksense script) :

cristianj23a — Thu, 10 Aug 2023 16:36:46 GMT

Hello, here I send you an example with the cross table.

Data:

LOAD * INLINE [
Product, January, February, March
Apples, 100, 150, 200
Pears, 50, 75, 125
];

Final:

Crosstable (Month, Sales, 1)
LOAD * INLINE [
Product, January, February, March
Apples, 100, 150, 200
Pears, 50, 75, 125
];

Regarts.