Count function

[sumonroy]

Hi all,

I am new to this community. Could anyone please help me out to write an expression in Qlikview Pivot Table.... I am trying to find 'Total Distinct Product Used by Each Customer ' (showing under expected result).

Product       Product Size         Customer Name       Sum (2017 Order$)           Total Distinct Product Used by Each Customer (Expected Result)      

A                            10                                  XXX                                       100                                                                           3                                                               

A                             12                                 YYY                                       200                                                                            2

A                             14                                 ZZZ                                      300                                                                            1

B                             10                                 XXX                                      100                                                                            3

B                              8                                   YYY                                      150                                                                            2

C                              8                                   XXX                                      150                                                                           3

C                              10                                XXX                                      150                                                                            3

Thanks in advance for your help!

[Gysbert_Wassenaar · Accepted solution]

count(TOTAL <[Customer Name]> distinct Product)

See this blog post for information about the TOTAL qualifier: https://community.qlik.com/t5/Qlik-Design-Blog/What-does-the-TOTAL-qualifier-do/ba-p/1472990

[sumonroy]

Thanks for such a quick reply....it's solved!!