Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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 (1)
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