Aggregation count based on count

[mastankomatla21]

Hi,

I have a scenario to get the Aggregated count based on the Count.

Table1:

Customer Name	Count (Transaction No)
AA	2
BB	1
CC	4
DD	7
EE	2
FF	1
GG	27
HH	18
II	8
JJ	1
KK	34
LL	8

Table2:

Size of Transaction No	Boxes
1	3
2	2
4	1
7	1
8	2
18	1
27	1
34	1

Based on the table1 I need to get the aggregated count of the count of transaction number.

Like how many 1's are present in the table 1 and how many 8's are present in the table1 likewise I need to store in a column called boxes.

Kindly suggest the possible way.

Thanks in advance

Mastan

[sunny_talwar · Accepted solution]

Try this

Dimension

Aggr(Count([Transaction No]), [Customer Name])

Expression

Count(DISTINCT [Customer Name])

[mastankomatla21]

Hi Sunny,

Its perfectly worked and I got the answer, thank you very much.

Thanks to qlik community.

Regards,

Mastan