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: 
rwb139
Creator
Creator

Combine Tables With Different Dimensions

Hello community,

I have a (potentially) unusual request. I have two tables, one with a dimension "Account Type" that includes values "Income", "Expense", "Other Income", and "Other Expense" and another one that I have created using a value list that combines these in different ways to create an NOI (Income - Expense), Total Income (Income + Other Income), Total Expense (Expense + Other Expense) and Net Income (Total Income - Total Expense). My question is how can I combine these tables to where the data shows up on my pivot table and my boss can more easily see the Total Income, Total Expense, and NOI. Please let me know if I can elaborate more, but he's really needing it to be in this format. 

rwb139_0-1610634983793.png

 

1 Reply
rwb139
Creator
Creator
Author

After playing with this for a long time, I was able to solve it by utilizing the ValueList() and then creating an excel pivot table and filtering out the 0 values.