Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ZoharB
Contributor III
Contributor III

Indirect value in a chart expression

Hi,

In a KPI I want to show a measure which is in a field.
For instance: instead of defining "count(cities)" as the measure I have a field in a table called "formula" and it contains different texts:
"count(cities)"
"Max(cities)"
"Avg(cities)" and more.
Also there is a way to select the formula I want (by another field in that table, such as INDEX).
My question - how do I write the  expression in the chart so that the text in the seledted  formula will be executed, in another words - indirect use of an expression?

Thanks

Zohar

Labels (3)
1 Solution

Accepted Solutions
marcus_sommer

By a table like described you may use a call like:

$(=only({< Index = {n}>} formula))

View solution in original post

2 Replies
marcus_sommer

By a table like described you may use a call like:

$(=only({< Index = {n}>} formula))

ZoharB
Contributor III
Contributor III
Author

Hi, thank you for your reply.

In fact I solved it even in an easier way.

I defined the variable vFormulaText = (Formula) and used vFormulaText in the KPI. Works perfectly.