Logic to only show range of values needed

[Thabang231]

Hi Team 

I would like an assistance, i wanna build a logic to only show a range of values from 30 to 60 inclusive, and this logic i would like to build in KPI, in the table and also put it in the bar graphs. So even when i pull the bar graph it show only show me the books ranging from 30 to 60 only and exclude the rest, how to build this. 

Thank you so much.

[Or]

Since you haven't included your expressions or sample data, it's hard to say exactly, but generally one would use set analysis, e.g.

Sum({< ValueField = {“>=30<=60”} >} SomeFieldName)

see e.g. https://community.qlik.com/t5/QlikView-App-Dev/range-with-set-analysis/td-p/252113

[Thabang231]

Hi @Or 

Thanks for this, and currently here is the formula i need to do the range on it, so with this formula i want it to only show me outputs which range on 30 to 60 only and it should ignore the rest : (sum(TripFuel)/sum(TripDistance))*100