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: 
Bobi
Partner - Contributor II
Partner - Contributor II

Sum with aggr?

Hi. I try to get the right sum when aggregating the department name from table A with sales from table C.

 

The date column and the revenue are in table C. But table B is connected to table C through company name and not department name. Same departmentname might exits in several company names, so probably some kind of distinct needed.

Tables are connected like this: Table A to B through departmentname. Table B to C through company-name. 

 

How do I do to correctly aggegate the revenue per each department? I have tried with different aggr expressions without succeding.

Labels (1)
1 Reply
y_grynechko
Creator III
Creator III

Can you share the screen of the tables?

Is there anything in the table C that states which revenue is under given department? 

If the data is just connected the way you explained you can aggregate revenue only by the Company Name and Date Fields.