topic Re: Count if in load script in QlikView

Count if in load script

Fri, 09 Aug 2013 17:51:31 GMT

Hello,

I need to count the id field on a table only if the field type=1. I need it in the load script, but I am getting an error.

Table:

Load

If(type=1,count(id),0) as field1

sql select * from ...

Is there a way to do this?

Thank you,

Juan.

sushil353 — Fri, 09 Aug 2013 19:05:38 GMT

I not sure what are u trying to achieve from this..

but you can calculate the count of field in sql script

Load field 1;

SQL Select Count(field) as field1

where type =1;

spividori — Fri, 09 Aug 2013 19:09:35 GMT

Hi.

try this: if(type=1,1,0) as field1

and then in the graphics you should use count (fiel1).

Regards.

VishalWaghole — Sat, 10 Aug 2013 17:36:59 GMT

Try to set the Flag for Type = 1 like this

if(match(Type,1),'Y','N') as Type1

and then use your flag in expression like

count({<Type1 = {Y}>}Type)

Thanks.

hic — Sat, 10 Aug 2013 19:58:00 GMT

Count works fine in the Load script, but you need to use a Group By clause, e.g

Load

type,

Count(id) as field1

Where type = 1

Group By type

;

sql select * from ...

HIC