Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
ugurarslan
Contributor

Count if count of a dimension is less than 1

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

 

7 Replies
pradosh_thakur
Honored Contributor II

Re: Count if count of a dimension is less than 1

in script use a where condition , It will do the job
Learning never stops.
ugurarslan
Contributor

Re: Count if count of a dimension is less than 1

Hi Pradosh, I do not have a script, we work with enterprise so I need to do it in the table itself.

 

Ugur

pradosh_thakur
Honored Contributor II

Re: Count if count of a dimension is less than 1

in UI

IF(Count(distinct[Invoice Nbr])<2,count(distinct[Invoice Nbr]),0)
and supress zero.
Learning never stops.
pradosh_thakur
Honored Contributor II

Re: Count if count of a dimension is less than 1

IF(Count(distinct[Invoice Nbr])<2,count(distinct[Invoice Nbr]),0)
and supress zero.
Learning never stops.
ugurarslan
Contributor

Re: Count if count of a dimension is less than 1

Thanks Pradosh, how do I suppress zero?

 

ugurarslan
Contributor

Re: Count if count of a dimension is less than 1

Hi, this unfortunately didn't work...

pradosh_thakur
Honored Contributor II

Re: Count if count of a dimension is less than 1

please show the output screenshot
Learning never stops.