Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Gauge Chart

Hello,

I created a gauge chart.

But i don't want that the gauge chart act on my selections box.

I want the gauge chart to act on my input box. I want two input boxes where people can select the years.

Is this possible and how can i do this?

1 Solution

Accepted Solutions
Employee
Employee

Re: Gauge Chart

You can do that and there is more than one way.

Adding {1} into each expression on the chart expression would cause it too disregard all user selections:

Sum(  Sales)  -->   Sum( {1} Sales)

What are your 2 input boxes ?  Variables or field selections  ?

If you select a year in your input box and store it as a variable called vYear you could do this..

sum( {1<Year={$(vYear)}>}  Sales )  

which would disregard all user selections except that the Year field would equal the variable value that the user sets in the input box.

2 Replies
Employee
Employee

Re: Gauge Chart

You can do that and there is more than one way.

Adding {1} into each expression on the chart expression would cause it too disregard all user selections:

Sum(  Sales)  -->   Sum( {1} Sales)

What are your 2 input boxes ?  Variables or field selections  ?

If you select a year in your input box and store it as a variable called vYear you could do this..

sum( {1<Year={$(vYear)}>}  Sales )  

which would disregard all user selections except that the Year field would equal the variable value that the user sets in the input box.

Not applicable

Re: Gauge Chart

Excellent Thx!

Community Browser