Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

sumonroy
Not applicable

Count function

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!

 

 

1 Solution

Accepted Solutions
Highlighted
Gysbert_Wassenaar
Not applicable

Re: Count function

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


talk is cheap, supply exceeds demand
2 Replies
Highlighted
Gysbert_Wassenaar
Not applicable

Re: Count function

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


talk is cheap, supply exceeds demand
sumonroy
Not applicable

Re: Count function

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