Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
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
ahmed_hassan
New Contributor III

Re: Slider to filter Top Customer

Partner
Partner

Re: Slider to filter Top Customer

Try to change ur measure as follow:

 

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

3 Replies
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
ahmed_hassan
New Contributor III

Re: Slider to filter Top Customer

Partner
Partner

Re: Slider to filter Top Customer

Try to change ur measure as follow:

 

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