Max Value (Including Selection)

danielle_v — Fri, 28 Jun 2013 12:22:16 GMT

Hi All,

I am trying to do an expression to calculate the max of ( sum (Value) / sum (quantity) ) by supplier. This is not a problem when no selection has been made on supplier.

However, I want the max ( sum (Value) / sum (quantity) ) still to show the max value across all suppliers, even when a selection is made on a supplier

For example, in the below, the max ( sum (Value) / sum (quantity) ) is 350, from supplier JKL. If I selected DEF for example, I would still want the figure to show 350 (not 200)

Supplier ( sum (Value) / sum (quantity) )

ABC 100

DEF 200

GHI 150

JKL 350

MNO 200

I've tried various expressions but can't seem to get the max value to remain the same when I select a supplier.

Any help much appreciated!

Re: Max Value (Including Selection)

tresB — Fri, 28 Jun 2013 12:28:13 GMT

In your expression you have to exclude the selection for Supplier like:

sum ({<Supplier=>}Value) / sum ({<Supplier=>}quantity) )

topic Re: Max Value (Including Selection) in QlikView

Max Value (Including Selection)

Re: Max Value (Including Selection)