Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Contributor II

Re: Sum One Dimenstion based on DISTINCT other dimension

Hi,

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

LOAD

SUM(PRICE) AS TotalProjectsPrice

;

LOAD distinct

,

PRICE

Resident ProjectPrices;

Angus.

qliksus
Valued Contributor

Sum One Dimenstion based on DISTINCT other dimension

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

is not working