topic Re: Counts based on Date in QlikView

Counts based on Date

anuradhaa — Wed, 25 Nov 2020 16:16:04 GMT

I want to get count when data is there,

So i use below expression

if(len(Date)<0,Count(Date)).

But it doesn't give any value.

if i use only count(Date) it return values. what was my issue

Anonymous — Thu, 03 Mar 2016 17:41:27 GMT

Maybe try something like this :

Count( if ( len(Date)>0 , 1 , 0 )

sunny_talwar — Thu, 03 Mar 2016 17:45:53 GMT

May be this using set analysis:

Count({<Date = {'*'}>} Date)

avinashelite — Fri, 04 Mar 2016 05:58:18 GMT

Try like this

if(len(trim(Date))>0,Count(Date))

tresB — Fri, 04 Mar 2016 06:06:48 GMT

You probably meant, Sum( if ( len(Date)>0 , 1 , 0 ). Otherwise, counting '0' (when the condition fails) also increases the count.

Anonymous — Fri, 04 Mar 2016 06:07:14 GMT

may be something like this?

=Count(if(len(trim(Date))>0,Date))

You can use Disticnt, if required?

jagan — Fri, 04 Mar 2016 06:14:30 GMT

Hi,

You can simply use

Count({<Date = {'*'}>} Date)

* ignores Null & Empty values.

If you want to deal this in script then try like below

LOAD

If(Len(Trim(Date)) >0, 1, 0) AS DateCount

FROM DataSource;

Now in Front end just use

Sum(DateCount)

Hope this helps you.

Regards,

Jagan.