Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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 ..

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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
Partner - Master
Partner - 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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

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.