topic Re: Count Fields in QlikView

Count Fields

Fri, 16 Oct 2015 07:36:47 GMT

Hi,

I have a easy example regarding to my problem. You will see a table which includes Start and End. Now the ID should counted when Start and End is not empty. How to build that?

Thanks...

Re: Count Fields

sunny_talwar — Fri, 16 Oct 2015 07:40:01 GMT

Try this:

=Count(if(Len(Trim(Start)) > 0 AND Len(Trim(End)) > 0, ID))

Re: Count Fields

rubenmarin — Fri, 16 Oct 2015 07:42:38 GMT

Hi Hans, you can use:

=Count({<End={"=Len(Trim(End))>0"}, Start={"=Len(Trim(Start))>0"}>} ID)

=Count({<ID={"=Len(Trim(End))>0 and Len(Trim(Start))>0"}>} ID)

Btw the empty fields aren't Null(), they have a blank value.

You can check when a value is null because you can't select it, in this case you can select the blank value.

Re: Count Fields

avinashelite — Fri, 16 Oct 2015 07:43:31 GMT

try this:

=count({<Start={"=if(len(trim(Start))>0 ,Start)"},End={"=if(len(trim(End))>0 ,End)"}>}ID)

Re: Count Fields

tresB — Fri, 16 Oct 2015 07:44:13 GMT

=Count( If( not (IsNull(End) and IsNull(Start)), ID))

In your sample End and Start are not really null, so try:

=Count( If( Len(Trim(End))>0 and Len(Trim(Start))>0, ID))

You could you set analysis as well.