Move Chart Value on the basis of Slider

[#1]

Hi,

I have a bar chart with a range dimension. (class function). Dimension Name - DIM (suppose)

0-10

10-20

...

...

90-100

I have a slider having lower limit as 0 and higher as 100.

I want if anyone moves slider the data in the chart get filter automatically and all bar above the slider value should display.

Say if I move the value of slider to 70. only ranges 70-80, 80-90, 90-100 would display in the chart.

I m not able to link it correctly.

Please help.

Regards,

Sachin A.

[#2]

Hi Sachin,

if you load only DIM field in separate table and rename it (for example DIM_Slider just not to be linked with other tables) then use  DIM_Slider field for the slider. And the expression for the chart will be

sum( {<DIM={">=$(=only(DIM_Slider))"}>} Amount)

This will cause the chart to filter records with DIM >= than selected values in slider object

Attached is a sample file with the same logic.

Hope this helps!

Stefan