Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
valerio_trotta
Contributor III
Contributor III

Range Slider filter in QlikSense

Hi Everybody!

 

I need to achieve a very simple range slider filter in QlikSense. 

So far I've understood that i need an extension but I've tried many of those and no one is working.

What i need is very simple, i have a table showing products  with prices, and i want the user to be able to select a price range on a slider that will filter the table.

Anyone of you has a stable method to do so?

Thanks

VT

12 Replies
Wayne_101
Contributor III
Contributor III

hi,

same here,i haven't used any avg function in my price selection filter but still below sum(sales) show values out of the range.that too in a specific range which is shown in screenshot no 4.

 

isn't there any other way to just give simple range filters where user has option of   > and < operator or can have  between clause, in simple words just a ranged filter. 

This functionality is so much easier in tableau and power hence in qlik sense i haven't came across one fully functional solution.  

 

my solution :

made 2 Variable :

vMax =max(sales)

vMin=max(sales)

 

then use above variables in sales measure like this : 

= if((sum(Sales) >= $(vMin) AND sum(Sales) <= $(vMax)),sum(TotalCalls))

which gives me following output in screenshot no 5  filtering the data but leaving blank in sales column where condition not met:

 

please help

Vegar
MVP
MVP

I had a look at the application on my computer and this is what I found regarding your first question. 

The selection object on the top is making selections in the price field values. In your example you are only selecting transactions containing prices between 330.08 to 478.73. In  my data model I have more than one transaction per customer and the sum of price could become larger than 1000. See attached screenshot below.

image.png

Reading your last comment it sounds like you want to make selection on customer based of sum of price . To do that you will need to adjust the distribution graph putting customer as dimension and sum(Price) as measure. See attached qvf.

image.png

 

JoseBel
Contributor II
Contributor II

great man thanks