Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
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
hic
Former Employee
Former Employee

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
hic
Former Employee
Former Employee

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

Not applicable
Author

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