How to crosstab in QlikView

FabioP — Sat, 16 Nov 2024 19:39:05 GMT

Hello,

I need to crosstab a column from a table and don't know how... What's is the way? By a pivot table or directly by the script?

That is what I have:

And, that is what I need:

Notes: The columns 1 and 3 are fixed and the column 4 became the main row with the values from column 2.

Thanks in advanced!!

Re: How to crosstab in QlikView

Stoyan_Terziev — Mon, 18 Nov 2019 15:18:02 GMT

Hi Fabio,

I hope you need to achieve this on the front end.

If yes:

1) Create a Pivot Table chart

2) Presentation -> check on Always fully expanded + Allow pivoting.

2.1) Presentation -> Fill in 'Missing' with '[Null]'

3) Add the Dimensions [Asset], [Line] and [Date]

4) Add measure Avg([Fator])

5) Drag / Drop the dimension Date horizontally.

If you need to do it on the back-end: Check the 'Generic Load' QV funciton.

I hope that helps!
Kind regards,

S.T.

topic How to crosstab in QlikView in QlikView

How to crosstab in QlikView

Re: How to crosstab in QlikView