topic Re: sumif in scripts in QlikView

sumif in scripts

Anonymous — Wed, 24 Sep 2014 20:37:57 GMT

Hi, can i use sumif in the scripts? I used the following in the scripts but i got an error in expression..

sum(if((QuarterID - 12),Revenue) as NewRevenue

Thanks!

Anonymous — Wed, 24 Sep 2014 20:39:40 GMT

something like that

sum(if(QuarterID - 12 = 0,0,Revenue)) as NewRevenue

maxgro — Wed, 24 Sep 2014 21:03:10 GMT

with this test data

load * inline [

Year,Quarter,Revenue

2010,1,100

2010,2,100

2010,3,100

2010,4,100

2011,1,100

2011,2,100

2011,3,100

2011,4,100

];

you can have this script

load

if(Quarter=12,Revenue,0) as NewRevenue

Resident a;

or this

load

Year,

sum(if(Quarter=12,Revenue,0)) as NewRevenue

Resident a

group by Year;

anbu1984 — Thu, 25 Sep 2014 01:23:12 GMT

Bracket is missing in your statement

sum(if((QuarterID - 12),Revenue)) as NewRevenue

Anonymous — Thu, 25 Sep 2014 17:38:29 GMT

Thanks!