Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
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!!!!

1 Reply
Vegar
Partner
Partner

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

I recommend you to read @Henric_Cronström blog post
https://community.qlik.com/t5/Qlik-Design-Blog/The-Generic-Load/ba-p/1473470
Plees ekskuse my Swenglish and or Norweglish spelling misstakes