Input value using a range Slider

[Kandimal]

hello all,

I have received a requirement from my users,

looking for a functionality using Slider, they want to input the range(from and to values) instead of drag and drop to see the values. this needs to be based on transaction amount.

for ex, user wants to enter the transaction amount from $10 to $100 and my table should be filtered with that data.

for this, i have created a global variables - min(tran_amt) and max(tran_amt)... calling these global variables in range slider under from and to. now in my table, i made one dimension to show fixed number under limitation but the data isn't getting filtered.

Could some one please help me on how to achieve this? If i try regular slider for top10 or bottom 10 then it's working fine.

from the below image, user ideally should be entering the values in the text box and the slider should be moved accordingly along with data filter

[GregoireVG]

Hello @Kandimal ,

Could you provide a sample from your data or an app with dummy data?
Because you're on the right path so I don't fully understand what you need and what's missing.

[Kandimal · Accepted solution]

Hi Greg,

@GregoireVG 

Thanks for the reply, as you rightly mentioned I was in the right direction and here is how I have achieved it.

i was initially missing the connection between my sliders (variables) and tables/chart. to establish the connection, 

previously, my condition was

(if(product_name='deposit',(min_valulue),if(product_name=('deposit'),max_value),amount))

After making changes to set condition, my condition was

=aggr(if(only({<product_name={'deposit'}>}amount)>=$(min_value) and only({<product_name={'deposit'}>}amount)<=$(max_value),amount),amount)

with the above condition, I can either enter a value inside the "range slider" or drag the slider buttons.

thanks