Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Nov. 30th, Webinar! Do More With Qlik Cloud Catalog & Lineage: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
arsallee3
Contributor III
Contributor III

Pivot table calculation not totaling correctly

Good day Community,

Hoping can assist me on this. Sample file attached as well. 

Loading info from SQL tables. Desire to sum up quantity of barrels by region, service type, customer, well and then calculate revenue generated from this. Cost table with Region, customer, service type and chemical along with sales price for that. 

Also desire to calculate chemical cost same way. My issue is with joining of tables I get duplicated barrels quantity so it sums up incorrectly for revenue. If I separate which currently have then not able to get the chemical cost to total up correctly with pivot. 

May be way off on load or calculations.

May need to provide more info. Please let me know if do. 

Labels (3)
1 Reply
Anil_Babu_Samineni

Hard to say that as you have used "Left Join" many cases. Can you please provide sample Pivot table which is not working?

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)