Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlik
I am trying to create a calculation with variables that looks like this:
TN/(fn+TN)
Each one of the parameters is variable that I created in variable expression (not script). Here are the calculations:
TN --> count({$<result={"tn"}>}[test ID])
fn --> count({$<result={"fn"}>}[test ID])
This calculation I trying to show in Text & Image chart like KPI (only measure). What I get is a blank window in the Text & Image chart.
What can be the problem with using the variables?
Thank you.
This calculation I trying to show in Text & Image chart like KPI (only measure).
in a text object try
=$(TN) / ($(fn)+$(TN))
You need a dollar expansion for the variable to evaluate, give this and the related threads a read to know better
The Magic of VariablesThe Magic of Variables