Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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
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
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 ....