Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would need to change the active measure on a chart based on a combo box selection in my mashup. The measures are defined in the measures section. I thought the easiest way to do this would be to assign all the measures as alternatives dimensions and set the active one using the mashup API. But I cannot find the method to set the active alternative measure in the documentation.
Is there an API method to set the active measure in a chart? Otherwise, can we change programmatically the measure? I know I can set variables, but I cannot call a measure using a variable as far as I know...
Thank you!
Actually, I think the alternative dimension idea won't work... I need KPIs to change also, and they don't support alternative dimensions...
Hi,
You can switch or change measures and dimensions with the Qlik Sense .NET SDK ‒ Qlik Sense, You can find more examples on Qlik Branch.
Best regards
Lars-Göran Book
Hi Maxime,
You could use a variable instead and use the variable extension on Qlik Branch. That way you could also change a number of charts, KPIs etc at the same time, with just one click.
Hope this helps
Erik
Hi,
I figured out how to change the formulas or part of them using variables, but is it possible to point to a predefined measure?
Thanks!
I'm currently searching for similar idea. Did you find a solution using the API?
Hi Hans,
I did not find how to point to predefined measures, but we are now using variables for each measure, so it would be easy to switch between them.
For example:
LET vL.ClientCost = SUM([Client Costs Field])
LET vL.ClientRevenue = SUM([Client Revenues Field])
LET vL.SwappableMetric = $(vL.ClientCost)
And in your metrics, you could simply use the variable value.
For example, My [Client Costs] metric would be $(vL.ClientCost).
Hope this helps!
Hi Maxime
Thank you for the response! I decided to go another route and generate the Qlik graphs "on the fly" in JavaScript, allowing dynamic switch between dimensions/measures/graph type etc. throught the front-end.