Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sifatnabil
Specialist
Specialist

Combining straight tables

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?

Screenshot for QV Community.png

1 Solution

Accepted Solutions
sunny_talwar

13 Replies
Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
sifatnabil
Specialist
Specialist
Author

Hi, please see attached.

stabben23
Master
Master

Just build a pivot table With 4 Dimension and one Expression

sifatnabil
Specialist
Specialist
Author

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.

Screenshot for QV Community 2.png

Anil_Babu_Samineni

PFA

Capture.JPG

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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
Specialist
Specialist
Author

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

Brand

..

..

Product

..

..

sunny_talwar

Check attached

Capture.PNG

sifatnabil
Specialist
Specialist
Author

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.