Referencing an Expression in another Expression

[#1]

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

• Customer
• Time
• Exposure
• Exposure_Limit

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]

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

[#3 · Accepted solution]

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.

[#4]

Thanks for the help.