topic Re: Filtering Table data based on Range Slider in App Development

Filtering Table data based on Range Slider

Neha7 — Wed, 07 Feb 2024 02:53:11 GMT

Hello,

I am new to Qliksense platform and have just began creating an app.

I have a table with Columns like: City, Year, Month, ProductID, StoreID,Price, Quantiy, where productID is a number like 0,1,2,...6000.

I have to create a slider(s) to select Minimum ProductID and Maximum ProductID based on which the rows in the table visual should get filtered.

Currently, using single or multiple slicer to select minimum and maximum value would work for my use case.

I tried exploring the forums as well as using variable input visualization for the purpose but couldn't create a reliable solution.

I would appreciate any help with the case.

Thank you.

Re: Filtering Table data based on Range Slider

Nagaraju_KCS — Wed, 07 Feb 2024 05:15:42 GMT

Try this..

Create two variables

vMinProduct = Min(ProductID)

vMaxProduct = Max(ProductID)

Expression: =SUM({<ProductID={">=$(vMinProduct)<=$(vMaxProduct)"}>}Sales)

Re: Filtering Table data based on Range Slider

LRuCelver — Wed, 07 Feb 2024 07:12:28 GMT

Final result using 2 variables and a simple expression for the dimension:

I've created 2 variables: vMinProductID and vMaxProductID.

The sliders for the variables are set up from 0 to 6000. You can adjust the values dynamically if you want to. The input boxed are used for a more precise input.

For the dimension I've used this expression:

=Aggr(If(ProductID >= vMinProductID and ProductID <= vMaxProductID, ProductID), ProductID)

Make sure to disable the checkbox "Include null values".

Filtering the dimension in the table will filter the ProductID field.

Re: Filtering Table data based on Range Slider

Neha7 — Wed, 07 Feb 2024 22:12:54 GMT

Hello,

Thank you for your suggestion.

I tried implementing similar expression but it can't handle the case when no value is provided as input in the minimum or maximum limit box/slider.

I did set the values as 0, 10000 while defining the variables but it doesn't helps.

Expression:

=aggr(

if(

ATA>= if(LEN($(vProdIdMinLimit))<1,0,$(vProdIdMinLimit))

and

ATA<= if(LEN($(vProdIdMaxLimit))<1,6650,$(vProdIdMaxLimit))

ProductID)

,ProductID)

I also tested using Isnull function.

Re: Filtering Table data based on Range Slider

Neha7 — Wed, 07 Feb 2024 22:15:22 GMT

Hello,

Thank you for your advise.

I tried implementing similar expression but it couldn't handle the case when no value is provided as input in the minimum or maximum limit box/slider.

I did set the values as 0, 10000 while defining the variables but it doesn't helps.

Expression:

=aggr(

if(

ATA>= if(LEN($(vProdIdMinLimit))<1,0,$(vProdIdMinLimit))

and

ATA<= if(LEN($(vProdIdMaxLimit))<1,6650,$(vProdIdMaxLimit))

ProductID)

,ProductID)

I would appreciate any further suggestions.