Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Sum of Price Value

From below table i want to calculate sum(Price) for each unique ItemID price must come  only once.

Means result will be sum(Price)=80 not 170

ItemID            Price

1                      10

1                      10

1                      10

2                       20

2                       20

3                       50

3                       50

4 Replies

=Sum(Aggr(Only(Price), ItemID))

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP
MVP

Maybe

=Sum( Aggr( Only(Price), ItemID))

But I would rather fix this in the data model, seems like you joined a table where a linked table might be better.

Champion
Champion

may be:

Take ITemID as a Dimension

Expression:  sum(<total ITemID> Price)

Creator II
Creator II

Thanx to all guys