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
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?