Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
FabioP
Contributor II
Contributor II

How to crosstab in QlikView

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:
FROM.JPG

And, that is what I need:
TO.JPG


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!!

Labels (1)
1 Solution

Accepted Solutions
Stoyan_Terziev
Partner - Creator III
Partner - Creator III

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.

View solution in original post

1 Reply
Stoyan_Terziev
Partner - Creator III
Partner - Creator III

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.