Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ugurarslan
Creator
Creator

Show me all customers who only received one invoice

 

Dear,

I have a table where I display the count of invoices per customer.  The expression I use is  count(distinct[Invoice Nbr]).

Now the table shows the following:

Customer

Count of invoices

ID A

1

ID BE

4

ID R

3

ID RO

5

ID F

2

ID Z

1

 

In the table I would like the table to show/display me all customers where the count of invoices is less than 2. 

Example of how the table should look like:

Property

Count of invoices

ID A

1

ID Z

1

 

Please help me, thanks

 

Ugur

Labels (1)
2 Replies
sunny_talwar

Try this

Count(DISTINCT {<[Invoice Nbr] = {"=Count(DISTINCT [Invoice Nbr]) = 1"}>} [Invoice Nbr])
bhargav_bhat
Creator II
Creator II

try this

if( count(distinct[Invoice Nbr]) < 2, count(distinct[Invoice Nbr]))

and in Data Handling option uncheck include zero values 

 

Regards,

Bhargav