Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
SaraiMoH
Contributor II
Contributor II

How to transpose rows to columns

Hi! I'm pretty new to Qlikview. I'm working on a report which compares the retail volume between a period and the previous one. I calculated a lot of "complex" (long) expressions within a pivot table chart and the result looks like this:

Help1.png

The column after country contains the labels from the expressions I created and the next column is the result of the expressions. My intention is to create a stacked bar chart consisting in 3 series: RISE, FALL and BASE with 5 categories each (RV_201901, CC, VD, PR and RV_201902) so I need for the pivot table to look like this:

Help2.jpg

but if I just pivot (drag) the column with the expression labels to the column side it transposes the table completely and that's not what I need.  I want to keep the 5 categories as dimensions and transpose only the 3 series.  I have  no idea on how to do this. If it's possible to give a name to the column which contains the labels of the expressions and to the column which contains the results of the expressions?

I need a graph like this:

Help3.jpg

And this is how is looking right now because I could only transpose all values:

Help4.jpg

Thanks so much for helping me!!!!

Labels (4)
1 Reply
Vegar
MVP
MVP

Take a look at the genetic load feature to solve this issue.

I recommend you to read @hic blog post
https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470