Display Qlik Excluded Values in a Chart

[montero_ro]

Hello everyone,

I am trying to display the customers who ARE NOT buying a specific product. For this reason, I have tried some formulas,  such as count({<IDCUSTOMER=E(IDCUSTOMER)>} DISTINCT IDCUSTOMER and count({1-$} IDCUSTOMER  but no avial. In the image, I have the total customers who actually buy a product and below the ones who do not buy that specific item. It should show 9 customers.

Does anyone how can I achieve this?

Thanks a lot!

[BrunPierre]

Hi, like this?

Count( {$<Customer = E({1<Product={‘SpecificProduct’}>})>} IDCUSTOMER )

[vinieme12]

try

count({1}distinct cust)-count(distinct cust)

[tresesco]

I guess getexcludedcount() is exactly for that

[montero_ro]

I had tried something like that before, but this time I do not have a specific product that I want to exclude. I'd like to display a bar chart with all the products and the value to display would be the total count of customers that have not bought that specific product.

[montero_ro]

It kind of works, but if you don't have any selections, the chart does not display data.

[PedroNetto · Accepted solution]

Hi @montero_ro !

Try: Count( {1<IDCUSTOMER = E({$<IDCUSTOMER ={'*'}>})>} IDCUSTOMER )

[montero_ro]

Hi there @PedroNetto I ended up using the following formula:

vTotalCustomers - Count(DISTINCT IDCUSTOMER) where vTotalCustomers has this expression

Count({<PRODUCTNAME>}DISTINCT IDCUSTOMER)

It works fine!

Thanks!