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: 
Not applicable

Sum One Dimenstion based on DISTINCT other dimension

Hi community--I need some help! 

I am trying to sum (Price) column, but only for unique Project ID#s in another column.  Some Project IDs appear more than once, but I only want to sum them one time.  I've tried aggr functions and some load DISTINCTs with no success. 

I want to Sum dimention PRICE for distinct PROJECT ID#s

Thanks for taking time to help!

2 Replies
gussfish
Creator II
Creator II

Hi,

I'd suggest doing this in two stages, using chained loads:

LOAD

SUM(PRICE) AS TotalProjectsPrice

;

LOAD distinct

,

PRICE

Resident ProjectPrices;

Angus.

qliksus
Specialist II
Specialist II

Can you upload some temp data so that we can see why load Distinct or aggr

is not working