topic Referencing an Expression in another Expression in QlikView

Referencing an Expression in another Expression

Sat, 16 May 2009 00:27:49 GMT

I'm trying to create a stacked bar chart from a table with the following columns:

Customer is defined as a Dimension.

Max(Exposure) is defined as an Expression.

How can one return the minimum Exposure_Limit for each Customer/Max(Exposure) pair.

Thank you,

Ben

yblake — Sat, 16 May 2009 17:03:11 GMT

you can get a calculated dimension with aggr(max(exposure),customer)

Thu, 21 May 2009 01:25:46 GMT

Thank you to gorombel for this technique, which he posted here originaly.

I believe this expression should do the trick:

Min({<Exposure={"$(=Max(Exposure))"}>} Exposure_Limit)

A full QV file with the solution is attached.

Thu, 28 May 2009 00:49:14 GMT

Thanks for the help.