topic Make a query with a certain value range in QlikView

Make a query with a certain value range

Anonymous — Mon, 29 Jan 2018 20:39:20 GMT

Good day.

I have the following expression sum ([Q1 CAT]) which gives me some data in percentages from 0% to 100%. I want to know if there is a function on this expression that brings me those results but in a certain range That is, that is above 80%, less than 50% or between 50% and 80%.

I appreciate the collaboration.

Re: Make a query with a certain value range

petter — Mon, 29 Jan 2018 23:22:14 GMT

You could do something like this:

If(Sum([Q1 CAT])>0.8,Sum([Q1 CAT]))

If(Sum([Q1 CAT])<0.5,Sum([Q1 CAT]))

If(Sum([Q1 CAT])>=0.5 AND Sum([Q1_CAT])<=0.8,Sum([Q1 CAT]))

Re: Make a query with a certain value range

Anonymous — Tue, 30 Jan 2018 12:22:55 GMT

Thanks Petter, that's exactly what i needed