Is there a way to make columns in qlikview be merged?

[#1]

Hi all,

Is there a way for me to merge a column as a row?

So for example, in QV, my chart looks something like this

                                  Cloud 2014 Act    Cloud 2015 Act   Cloud 2016 Act       SASS 2014 ACT   SASS 2015 ACT SASS 2016 ACT

Revenue

Direct Expenses

Indirect Expenses

Is there a way to make it look like this?

                                                                      CLOUD                                                                     SASS

                                      2014 Act               2015 Act              2016 Act           2014 Act               2015 Act              2016 Act   

Revenue

Direct Expenses

Indirect Expenses

Like some type of grouping?

[swuehl]

You can use a pivot table to create a visualization like this, having two dimensions, one for the CLOUD / SASS grouping, one for the Year Act grouping.

If possible, create your dimension fields in the script, or use calculated / synthetic dimensions.

[#3]

Can you give an example please?

My columns are expressions.