topic Make mini-chart dynamic depending on value in slider in QlikView

Make mini-chart dynamic depending on value in slider

Sun, 02 Oct 2011 22:58:43 GMT

Hi,

I have a mini-chart within a table that I would like to change depending on what the slider at the bottom select (RiskRange)

So, I'd like the ability to filter the lines on chart ‘Indicators’ depending on what the percentage level is set to on the slider.

I've attached the sample .qvw

I'm sure I've seen this achieve before, but don't know where to start.

Any ideas or suggestions on how I can achieve this?

Many thanks!

Make mini-chart dynamic depending on value in slider

Anonymous — Mon, 03 Oct 2011 07:30:54 GMT

Hi there,

I have one idea, but dont know if it will be easy.

What I think you have to do is make the calculation of the [% Eng Score] in your script so you have a field with that score (grouped by studentnumber). Then you can use this field in your calculated dimension as somthng like this:

IF([% Eng Score] < Max(RiskRange), Student Number)

And then use the Supress When Value is Null option.

Re: Make mini-chart dynamic depending on value in slider

Anonymous — Mon, 03 Oct 2011 07:55:48 GMT

I tried some things.

Take a look at the atteched file, maybe it can be helpful.