Skip to main content
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
Showing results for 
Search instead for 
Did you mean: 
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






Labels (2)
0 Replies