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