Qlik Community

Ask a Question

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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: 
keith_yung
Contributor
Contributor

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