Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
Thanks for such a quick reply....it's solved!!