Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Live Chat, June 29th 10AM ET. Bring your Qik Sense Enterprise, Client Managed questions! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
APHardeau
Contributor II
Contributor II

Summary table from large data sets

I'm having difficulty in summing values in a column based on a value elsewhere. What I am trying is basically a SUMIF from Excel.

I want a new table that shows each unique Agent, with a sum column for Material Revenue when they are the Reporting Agent, and one column with the sum of Material Revenue when they are the ShipTo Agent. As QSense likes rows, when a Reporting Agent is not the ShipTo Agent, that revenue is not attributed to the ShipTo Agent under owning revenue.

Using the example under this, I am trying to make a table as follows (note that there are in actuality some 65 agents):

Agent | Owning                            | Delivering

X738   | SumIf X738 is ShipTo  | SumIf X738 if Reporting

ReportingShipToSum.png

 

 

 

 

Labels (2)
0 Replies