Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
subrato312
New Contributor II

Slider to filter Top Customer

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

Labels (3)
3 Solutions

Accepted Solutions
Highlighted
Partner
Partner

Re: Slider to filter Top Customer

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

Mark

View solution in original post

Highlighted
ahmed_hassan
New Contributor III

Re: Slider to filter Top Customer

Highlighted
Partner
Partner

Re: Slider to filter Top Customer

Try to change ur measure as follow:

 

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

View solution in original post

3 Replies
Highlighted
Partner
Partner

Re: Slider to filter Top Customer

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

Mark

View solution in original post

Highlighted
ahmed_hassan
New Contributor III

Re: Slider to filter Top Customer

Highlighted
Partner
Partner

Re: Slider to filter Top Customer

Try to change ur measure as follow:

 

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

View solution in original post