Distinct counts in Pivots Objects in QlikView

[Anonymous]

I know how to count only distinct IDs in a pivot but how do I make sure the count does not include blank IDs? I don't want Qlik to count blank ID as a unique ID. Thanks.

[vishsaggi]

Can you share some sample data with expected output?

[Anonymous]

  Suppose I want my pivot to count the number of distinct IDs in Program 1. It should say the distinct count is three (A, B, and C). I don't want it to count the one blank ID also and say the total distinct count is 4.  

Program	ID
Program 1	A
Program 1	B
Program 1	A
Program 1
Program 1	A
Program 1	C

[vishsaggi]

Did not get you? Is your total distinct count should be 3 or 4?

[vishsaggi]

Try this in your expr to get 3.

= count({< ID = {"=Len(Trim(ID)) <>0"} >} DISTINCT ID)