Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.


Chart expression to lookup reference table?


I am trying to calculate a total price within a chart table when the unit price depends on two aggregated values(volume & service level).  The unit price is the same across all units so I just need a way of using the aggregated values to look up a reference table but there doesn't seem to be a chart function to do this?  "Lookup()" would be ideal but it is only available as a script function.

Can anyone suggest a suitable chart function or an alternative approach?


Tags (2)
1 Reply
Valued Contributor II

Re: Chart expression to lookup reference table?

Maybe the  only() function works (...if [ExpressionTotal] = only(LookUpField)  )  , if there is one (lookup) value only else it returns false