Slider Filter

[marleygt]

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 .

[#2]

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.

[marleygt]

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

[Peter_Cammaert · Accepted solution]

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

[marleygt]

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

[Peter_Cammaert]

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

[stipas]

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