Discussion Board for collaboration on QlikView Scripting.
I want to convert the table-1 in the table-2 format as specified above. Can anyone give your ideas ?
Go to Solution.
PFA the solution to your question
you should copy paste the pivot sub and then call :
CALL fr.qliktech.pivot('Table 1', 'Product', 'Sum', 'MetricValue', 'Target');
You could do it the other way around using the unpivot function
Yes, don't do it in the script. Use a pivot table object with Product and MetricValue as dimensions. Drag the header of MetricValue to the right above the expression so the dimension values are shown horizontally.
Your document gives me the expected results. Thanks a lot!