topic Re: SUMIF in QlikView

SUMIF

Anonymous — Thu, 19 Nov 2015 14:08:30 GMT

How would I SUM IF in the script?

For example I want to SUM Category if type = 'Start', if issues = 'None' and if Number1 = 20

Sum(IF(Category = 'Start' and(Issues= 'None') and(Number1 = '20'),1,0) as [TestCount],

Re: SUMIF

sinanozdemir — Thu, 19 Nov 2015 14:11:32 GMT

Hi,

How about this one?

Sum(IF(Category = 'Start' and Issues= 'None' and Number1 = '20' ,1,0)) as [TestCount],

Re: SUMIF

rubenmarin — Thu, 19 Nov 2015 14:13:55 GMT

Hi, in script you are loading values row by row, to use Sum() in script you'll need to group your data using 'Group by', so there are more than one value to sum.

In your script maybe you don't need that, just mark each record as '1' or '0' and do the sum in the chart.

Script:

IF(Category = 'Start' and Issues= 'None' and Number1 = '20',1,0) as [TestCount],

Design (chart):

Sum([TestCount])

Re: SUMIF

sunny_talwar — Thu, 19 Nov 2015 14:14:00 GMT

May be this:

Table:

LOAD Category,

Issues,

Number1,

OtherFields

FROM source

Join(Table)

LOAD Count(Category) as [TestCount]

Resident Table

Where Category = 'Start' and Issues = 'None' and Number1 = 20;

Re: SUMIF

Mark_Little — Thu, 19 Nov 2015 14:14:22 GMT

HI,

The below will give flag which can be be counted in the front end

IF(Category = 'Start' and Issues= 'None' and Number1 = '20',1,0) as [TestCount]

Or below

Load

KEyField,

IF(Category = 'Start' and Issues= 'None' and Number1 = '20',SUM(1)) as [TestCount]

Resident 'Your table'

Group by 'the field you want counting by' //I.e. Product category.

Mark

Re: SUMIF

sinanozdemir — Thu, 19 Nov 2015 14:16:58 GMT

Didn't pay attention you said in the script. sunindia‌'s answer should work in this case.