Combining straight tables

[sifatnabil]

Hi all,

I have the below 5 similar straight tables with different dimensions but exact same expressions, but I want to combine them. This is because it's a hassle to maintain and do column sorts (need to sort column 5 times for example). Is this possible in Qlikview?

[Anil_Babu_Samineni]

May be possible, Please share sample application to work ..

[sifatnabil]

Hi, please see attached.

[stabben23]

Just build a pivot table With 4 Dimension and one Expression

[sifatnabil]

Hi, building a pivot will place dimensions horizontally like below. I'm trying to get the dimensions to be on top of each other like in my original post.

[Anil_Babu_Samineni]

PFA

[sunny_talwar]

I think a simple expression like this should work here... don't need to repeat the same expression multiple times

Sum(Revenue)

[sifatnabil]

Thanks - Is there a way to bring in the dimension names in the table? e.g.

Brand

..

..

Product

..

..

[sunny_talwar · Accepted solution]

Check attached

[sifatnabil]

Hi stalwar1‌, This is great - is it possible to sort the expression column by numeric descending? I'm not able to sort the expression column at all. Thanks.