Column to row

Shirazc123 · ‎2023-08-10

Hi!

I need to get from option 1 to option 2.

how can I do that?

Thanks!

JHuis · ‎2023-08-10

Yes,

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

cristianj23a · ‎2023-08-10

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.

https://www.linkedin.com/in/cristianjorge/
Do not forget to mark as "Accepted Solution" the comment that resolves the doubt.

Related Topics