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
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Bobi
Partner
Partner

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 (2)
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.