Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT

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