Count distinct on multiple selections

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

Hi Experts,

Below is my table

LOAD * INLINE [

id, product

1, A

2, A

3, A

4, A

1, A

2, A

3, B

4, B

5, B

6, B

7, B

5, B

7, C

8, C

9, C

10, C

8, C

9, C

];

The above table contains duplicate id's by product.

when i wrote expression count of distinct id in text object.

i have a listbox called product when i made selection on product A it is giving the count 4 which is true.

here if i made selections on A and B at a time i have to get the count 9 which means for A is having the distinct value of 1,2,3,4

and for B having the value of distinct 3,4,5,6,7

my total count would be 9 but i am getting the count is 7 when i wrote count of distinct id.

Re: Count distinct on multiple selections

Fri, 03 Mar 2017 02:33:18 GMT

Hi Hari,

Have a look at the attached application.Hope it helps!