Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Set variable from gauge

Hi everyone,

I've got a gauge like this : gauge.png

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 !

1 Solution

Accepted Solutions
Highlighted

Re: Set variable from gauge

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

View solution in original post

2 Replies
Highlighted

Re: Set variable from gauge

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

View solution in original post

Highlighted
Not applicable

Re: Set variable from gauge

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 ....