QlikView PivotTable

[VadimCosman1]

Hello everyone,

I hope you are doing excellent 🙂

I have a question:

In my delivery, the business would like to have a PivotTable(Right Side of the attachment), currently we have implemented the PivotTable(Left Side of the attachment).

Is there any possibility to merge the rows of the column Metric1 so that it is related to the COMMODITY column, but the Metric2 should be as it is - related to the REASON NAME column? I know that is it possible in Excel, but could not find if/how it is possible in QlikView.

Thank you very much for your time and understanding,

Wish you a cool day/weekend!

[marcus_sommer · Accepted solution]

Within the expressions it's not possible. But you calculate it as a synthetic dimension with something like:

aggr(sum(Value), Dim1, Dim2)

whereby Dim1 and Dim2 are the placeholder for the dimensional context.

- Marcus