count distint empid's

[Anonymous]

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]

= fieldvaluecount('empid')

[Anonymous]

Maybe try this :

     Count ( DISTINCT empid )

[avinashelite]

Try like this

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

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

[ashfaq_haseeb]

Hi,

Try like this

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

or

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

Regards

ASHFAQ

[Chanty4u]

create in script as

set Nullvalue=' ' ;

and in frnt end

create a field as   

count(Distinct field)

[Anonymous]

Hi All,

I want create in script .

Regards,

Krishna

[Chanty4u]

hi,

create in script as

set Nullvalue=' ' ;

and

load *,

distinct urfields;