Range filters

Wayne_101 — Sat, 16 Nov 2024 19:30:05 GMT

Hi Experts,

My requirement is to have a ranged slider filter for multiple KPIS returning only the customer who comes in those ranges with those kpis in a table chart

i have 3 columns in attached Image:

1) MO (measure)

2) RC(Measure)

3)Customer ID(Dimension)

i wish to see only the customer Id's which comes in ranges of MO and RC with the columns MO and RC.

LOGIC APPLIED for measures:

= If (MO>= $(vMinMo) AND MO<= $(vMaxMo),MO)
= If (RC>= $(vMinRC) AND RC<= $(vMaxRC),RC)

LOGIC APPLIED for Dimension :

= If (MO>= $(vMinMous) AND MO<= $(vMaxMous)
or If RC>= $(vMinRC) AND RC<= $(vMaxRC),Customer_ID)

above expression for dimension also shows error but still kind of work do not understand why(attached as image)

ISSUE :

image 2 shows what i want to achieve and image 1 shows correct values but without MO column.

NOTE: i have more columns like MO and RC in my actual data set and would like to apply the logic seen in image 2 but with only the customers who comes in those ranges, if conflict then return the customer on last filtered range eg : RC but do not return null values.

Re: Range filters

andoryuu — Sun, 08 Dec 2019 23:10:13 GMT

@Wayne_101 you will find my reply this this here: https://community.qlik.com/t5/New-to-Qlik-Sense/RANGE-FILTERS/td-p/1655250.

topic Range filters in App Development

Range filters

Re: Range filters