Slider to filter Top Customer

[subrato312]

I have a bubble chart for top customers with Profit and Sales as X & Y axis and Profit% as size of bubble. 

I want a slider to filter customers with sales value e.g. customer with sales more than 10,000 only.

I tried by creating a variable as vTest and defined it as 1. Then I changed the measure 'Sales ' as sum(Sales)*vTest but it is not working properly when I am sliding the slider. The sales values are changing from thousand to millions and customers are not not reducing as per their sales

I am using qsVariable extension. Please let me know how to make this correct

Thanks

[Mark_Little · Accepted solution]

Hi,
You are just timing your expression by the number in your variable.
Try
If(SUM(Sales) <= $(vTest),
SUM(Sales))

Mark

[ahmed_hassan · Accepted solution]

Check this one please:
https://community.qlik.com/t5/New-to-QlikView/Slider-Filter/td-p/1002488

[OmarBenSalem · Accepted solution]

Try to change ur measure as follow:

sum({<Customer={"=sum({<Customer>}Sales)>'$(vTest)'"}>}Sales)