Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2017-02-28 02:06 AM

Distinct?

 

HI all expert!

I have this set of data,

   

Contact PersonContact NumberCOMPANY
MA11111111ABC
MA11111111DEF
MA22222222GHI
MB22222222JIL
MC33333333MNO
MD33333333PQR
ME33333333STU
ME33333333

VWX

ME3333333YZA

I would like to find out the number of cases where same contact person, multiple company. So in this set of data, it will be 2 (MA & ME both represent multiple company).

I would not like to touch my scripting as much as possible. How can I expression in my KPI to show the number of case.

Regards,

Jia

4,643 Views
0 Likes
10 Replies
Anonymous
Not applicable
‎2017-03-01 12:26 AM
Author

In response to OmarBenSalem

Hey Omar,

I understand that create a 'new field' contact&company and count it distinct:

But why do we have to use contact = 'the new field' and not other variables?

419 Views
0 Likes