topic Re: Distinct counts in Pivots Objects in QlikView in QlikView

Distinct counts in Pivots Objects in QlikView

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Distinct counts in Pivots Objects in QlikView

vishsaggi — Mon, 02 Jul 2018 21:58:17 GMT

Can you share some sample data with expected output?

Re: Distinct counts in Pivots Objects in QlikView

Anonymous — Mon, 02 Jul 2018 22:20:43 GMT

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

Re: Distinct counts in Pivots Objects in QlikView

vishsaggi — Tue, 03 Jul 2018 00:10:20 GMT

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

Re: Distinct counts in Pivots Objects in QlikView

vishsaggi — Tue, 03 Jul 2018 00:20:46 GMT

Try this in your expr to get 3.

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