Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to merge two pivot tables which have different dimensions and expressions?


Hi,

Can anyone suggest me please in this. I know merging of two pivot tables when both tables have same dimensions and expressions.

if both tables have different dimensions and different expressions how to merge two tables.

Please can anyone help me.

Thanks.

1 Reply
marcus_sommer

Normally they couldn't be merged. You could of course try it with quite complicated expressions (nested if- and aggr-constructions with totals and some set analysis) to force the dimension and expression to show your results. But this could be very expenses and if it worked the performance could be rather slow.

Therefore are there other options? Like changes within the datamodel or to show two or more objects parallel at the same time within a conatiner in grid-mode or ...

- Marcus