topic Re: Slider Filter in QlikView

Slider Filter

marleygt — Fri, 11 Dec 2015 15:45:32 GMT

Hi all!

I Need help and suggestions for this situation:

A Slider filter (or something similar) in order to limit data in pivot table for "min" and "max" value (that customer will choose by his own).

How to perform that if I have to consider at least 3 dimensions (Eg. "InitiativeName", "Brand" and "Places") and 2 fields (Eg. "Sales" and "Pieces")?

Some specs:

- It's not necessary to filter 3 dimensions at same time;

- the 2 fields are already available as an orphan table called "SalesPieces", which contains both fields, that I am using as desired with a connected variable. (vSalesPieces);

My problem: I don't know how to create right expression;

The main idea I suppose should be somewhat like Aggr(InitiativeName,$(vSalesPieces)>=vSlider) (in the "Data" field of slider properties - "Expression") - (where variable "vSlider" should contains the relative value from the user in the input box for min and max).

I found a lot of discussions, chiefly referred to "Date/Month" period. I tryed to convert in Value/Pieces but I just make a real mess.

Lost the way...need someone who could bring me back to the right way .

Re: Slider Filter

Fri, 11 Dec 2015 16:36:35 GMT

You can use slider/calendar object by selecting slider.

You can set the min and max values using a variable, it can be shown in input box to edit.

Re: Slider Filter

marleygt — Fri, 11 Dec 2015 16:44:12 GMT

Hi @vsaikrishna, thank you for reply!

What you suggest is ok, but I've already pass this point:

Problem is when I move slider, there is no effect on pivot table.

Need to clarify how to set correctly for let it work.

Point is: need to set manually a value inside the filter, or to fix it in the slider, and then moving the slider need to show only data in range.

Alex

Re: Slider Filter

Peter_Cammaert — Fri, 11 Dec 2015 19:34:57 GMT

How about using something like (for a single expression value):

=IF((sum(something) >= $(vSliderLow)) and (sum(something) <= $(vSliderHigh)), sum(something))

When your expression result falls outside the slider range, it will be replaced by a NULL value. And NULL values will disappear from a table.

Best,

Peter

Re: Slider Filter

marleygt — Mon, 14 Dec 2015 15:18:49 GMT

Hi pcammaert! Thank you for your reply and sorry for late answer.

Weekend tooks me away and have also other things to follow.

However, your solution was enough and perfectly working!

Now I am trying to implement in a very complex scenario...but for the moment it's ok!

Thank you very much!

Alex

Re: Slider Filter

Peter_Cammaert — Mon, 14 Dec 2015 15:42:01 GMT

No problem, Alex. Take your time. I'm not in a hurry, just glad that I was able to help.

Enjoy QlikView and the Qlik Community

Re: Slider Filter

stipas — Mon, 10 Feb 2020 13:44:54 GMT

Hello, apply this solution but, i am working ina simple table and i need to desapire the null field, any solution ??