topic Re: Logic to only show range of values needed in App Development

Logic to only show range of values needed

Thabang231 — Tue, 07 Mar 2023 13:25:23 GMT

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.

Re: Logic to only show range of values needed

Or — Tue, 07 Mar 2023 13:40:54 GMT

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

Re: Logic to only show range of values needed

Thabang231 — Thu, 09 Mar 2023 07:58:58 GMT

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