topic Re: count distint empid's in QlikView

count distint empid's

Anonymous — Mon, 28 Mar 2016 07:36:23 GMT

Hi,

Empid fild having null values.i want count distint empid's.

(How to use count ,Distinct, null functions in qlikview)

Regards,

Krishna

Kushal_Chawda — Mon, 28 Mar 2016 07:38:48 GMT

= fieldvaluecount('empid')

Anonymous — Mon, 28 Mar 2016 07:38:51 GMT

Maybe try this :

Count ( DISTINCT empid )

avinashelite — Mon, 28 Mar 2016 07:52:17 GMT

Try like this

// this will count the empid which are not null and DISTINCT

Count( DISTINCT {<EMPID={"*"}>}T EMPID)

ashfaq_haseeb — Mon, 28 Mar 2016 07:53:15 GMT

Hi,

Try like this

=Count({<empid={*}-{' '}>}DISTINCT(empid))

=Count({<empid={*}-{''}>}DISTINCT(empid))

Regards

ASHFAQ

Chanty4u — Mon, 28 Mar 2016 08:13:31 GMT

create in script as

set Nullvalue=' ' ;

and in frnt end

create a field as

count(Distinct field)

Anonymous — Mon, 28 Mar 2016 08:54:41 GMT

Hi All,

I want create in script .

Regards,

Krishna

Chanty4u — Mon, 28 Mar 2016 09:00:01 GMT

hi,

create in script as

set Nullvalue=' ' ;

and

load *,

distinct urfields;