Can't get proper unique ID count

[michael_andrews]

I have  pivot table and I'm trying to count unique ids vs a form. However, my count is not coming out as expected. Can someone tell me what I'm missing? I'm using the formula Count(distinct ExamID)

See attached for what my pivot table looks like.

The sql equivalent would be SELECT COUNT(1) FROM Exam WHERE Exam_Form = 'Rev15_FormD' GROUP BY ExamID

[sunny_talwar]

Awesome

Please close this thread down by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

[JL1996]

hello Sunny, 

it sounds like you are an expert in Qlik Sense. Do you mind to take a look at my question when you are available? thanks