topic Set variable from gauge in QlikView

Set variable from gauge

Fri, 15 Nov 2013 09:07:24 GMT

Hi everyone,

I've got a gauge like this :

This gauge depends of the year/month/job selected. So I want to store the number dynamically, everytime that this gauge changes. So I was thinking of putting it into a variable, but I'm a newbie with those goddamn variables in Qlikview.

Is there a way to do that ?

For the record, this is calculated like this : count( IDWorker )/12

Thanks !

Re: Set variable from gauge

hic — Fri, 15 Nov 2013 09:18:26 GMT

If you define your variable as '=Count(IDWorker)/12' in Document Properties -> Variables -> Settings for selected variable, then it will do what you want. But I do not understand why you would want to do this. Just use the formula instead...

HIC

Re: Set variable from gauge

Fri, 15 Nov 2013 10:10:25 GMT

I need it because at one point, I have to filter, and I need to keep the global year in mind to calculate a ratio.

That works by the way, I had tried it before, but without the $() before the name of the variable ....