This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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!!
I hope you need to achieve this on the front end.
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,
View solution in original post