Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
sumonroy
New Contributor

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

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

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
New Contributor

Re: Count function

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

Community Browser