Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
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.