Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Wayne_101
Contributor III
Contributor III

Range filters

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.

 

image 2.png

 

IMAGE 1.png

 

 ERROR(Customer_ID).png

 

Labels (2)
1 Reply
andoryuu
Creator III
Creator III