Qliksense - creating a measure only if values exist in other dimensions

[Anonymous]

Dear Qliksense users,

I'm stuck in creating a measure for a project. Let me try and describe it best.

My dataset has 4 Fields/Dimensions - ObjectID, LocationID, Date, Type

ObjectID	LocationID	Date	Type
A03347	loc0751	-	A
A03348	loc0752	5th Jan	-
A03349	-	6th Feb	B
A03350	loc0649	7th Mar	C
A03351	loc6050	8th Apr	D

In my analysis I want to count all the objectIDs which have existing(non 0 or not null) values in all 3 other fields. So in the case above,

Count(ObjectID) in Qliksense expression would give me an answer 5 while i am only expecting 2 as the answer.

To be a bit more clear, I only intend to count ObjectIDs A03350 and A03351 since the rest of the ObjectIDs have missing values in either LocationID, Date, or Type.

What is the best way to go about doing this?

Thanks folks.

[OmarBenSalem]

try this:

Count(distinct {<LocationID={"=len(trim(LocationID))<>0"},Date={"=len(trim(Date))<>0"},Type={"=len(trim(Type))<>0"}>} ObjectID)