Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Empid fild having null values.i want count distint empid's.
(How to use count ,Distinct, null functions in qlikview)
Regards,
Krishna
= fieldvaluecount('empid')
Maybe try this :
Count ( DISTINCT empid )
Try like this
// this will count the empid which are not null and DISTINCT
Count( DISTINCT {<EMPID={"*"}>}T EMPID)
Hi,
Try like this
=Count({<empid={*}-{' '}>}DISTINCT(empid))
or
=Count({<empid={*}-{''}>}DISTINCT(empid))
Regards
ASHFAQ
create in script as
set Nullvalue=' ' ;
and in frnt end
create a field as
count(Distinct field)
Hi All,
I want create in script .
Regards,
Krishna
hi,
create in script as
set Nullvalue=' ' ;
and
load *,
distinct urfields;