Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this
Dimension
Aggr(Count([Transaction No]), [Customer Name])
Expression
Count(DISTINCT [Customer Name])
Try this
Dimension
Aggr(Count([Transaction No]), [Customer Name])
Expression
Count(DISTINCT [Customer Name])
Hi Sunny,
Its perfectly worked and I got the answer, thank you very much.
Thanks to qlik community.
Regards,
Mastan