topic Re: Aggregation count based on count in QlikView

Aggregation count based on count

mastankomatla21 — Wed, 13 Sep 2017 11:58:33 GMT

Hi,

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

Table1:

Table2:

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 — Wed, 13 Sep 2017 15:22:30 GMT

Try this

Dimension

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

Expression

Count(DISTINCT [Customer Name])

mastankomatla21 — Wed, 13 Sep 2017 17:08:00 GMT

Hi Sunny,

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

Thanks to qlik community.

Regards,

Mastan