Range filters

[Wayne_101]

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.

 

[andoryuu]

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