Discussion board where members can get started with Qlik Sense.
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:
Count of invoices
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:
Please help me, thanks
Hi Pradosh, I do not have a script, we work with enterprise so I need to do it in the table itself.
Thanks Pradosh, how do I suppress zero?
Hi, this unfortunately didn't work...