topic Re: sum(if) for a specific selection in QlikView

sum(if) for a specific selection

Anonymous — Wed, 27 Feb 2013 08:33:10 GMT

Hi all,

I want to use the sum(if)-function for a specific selection (all values between 3999 and 5000). My idea is like this, but it doesen't work:

sum(if(booking> 3999 and booking< 5000, cost)) as cost_special

Thank you for your help!

Wed, 27 Feb 2013 08:42:18 GMT

Hi,

Try this

IF(SUM(booking)>3999 AND SUM(booking)<5000,cost) as cost_special

er_mohit — Wed, 27 Feb 2013 08:42:29 GMT

try this

sum(rangeonly(if(booking>3999 and booking<5000,cost)as cost_special

Wed, 27 Feb 2013 08:42:40 GMT

sum( total if(booking> 3999 and booking< 5000, cost)) as cost_special

Wed, 27 Feb 2013 08:44:30 GMT

Hi,

Try this

IF(SUM(booking)>3999 AND SUM(booking)<5000,SUM(cost)) as cost_special

sivarajs — Wed, 27 Feb 2013 09:01:18 GMT

sum({<booking={">3999<5000"}>}cost)

Anonymous — Wed, 27 Feb 2013 09:17:18 GMT

Thank you, but it doesn't work. QV says that there is a skript mistake.

Anonymous — Wed, 27 Feb 2013 09:20:59 GMT

Thank you, but it doesn't work. QV says that there is a skript mistake.

sivarajs — Wed, 27 Feb 2013 09:22:38 GMT

Set analysis wont work with script.Did you use Group by clause in your table

Load * sum(x)as tmp

from x.qvd group by y;

Anonymous — Wed, 27 Feb 2013 09:31:29 GMT

Thank you very much!! It works...

Anonymous — Wed, 27 Feb 2013 09:36:50 GMT

Thank you!

I use "group by", but if I comment it out it still didn't work.

I will take the solution provided by er.mohit.

Thank you very much for your help!