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

Set analysis with aggregation

Hi Qlik Community,

I am currently facing a problem of calculating a measure while ignoring certain fields.

Of course, it can be solved by utilizing set analysis like below

Sum({$<[Customer ID]=,[Customer Name]=>} [Weight])

However due to some reason the database is a link-up of two tables, in which when I calculated Total [weight],

it has to be calculated as

Sum(aggr(Only([Weight]), [Shipment ID],[Batch ID]))

When I tried to combine two functions like

Sum({$<[Customer ID]=,[Customer Name]=>}aggr(Only([Weight]), [Shipment ID],[Batch ID]))

it failed to give correct answer.


Can anybody suggest a correct solution?


BRgds,

Keith

0 Replies