topic Re: Variables calculation in QlikView

Variables calculation

Wed, 25 Nov 2020 16:16:04 GMT

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.

maxgro — Sun, 29 Jan 2017 08:18:23 GMT

This calculation I trying to show in Text & Image chart like KPI (only measure).

in a text object try

=$(TN) / ($(fn)+$(TN))

vinieme12 — Sun, 29 Jan 2017 09:28:36 GMT

You need a dollar expansion for the variable to evaluate, give this and the related threads a read to know better