remove nulls from count qlik sense

joeybird — Mon, 16 Jan 2017 11:34:29 GMT

on a table chart on qliksense I have the dimension CustomerID

I have the following expression measure on a table

if(COUNT(distinct{$<MonthChart= {"$(='>=' & MonthStart(AddMonths(Max(MonthChart),-2)) & '<=' & AddMonths(Max(EventDate),-0, 'DD/MM/YYYY'))"}>}orderid)>=4,

COUNT(distinct{$<MonthChart= {"$(='>=' & MonthStart(AddMonths(Max(MonthChart),-2)) & '<=' & AddMonths(Max(EventDate),-0, 'DD/MM/YYYY'))"}>}orderid))

This is counting correctly. However I want to remove the nulls counts against the other Customer IDs. I have tried unchecking the show nulls values box, and still no joy. please help

is there another way of count if any customer has made 4 or more orders in the last 3 months (from a month chosen)? to prevent the nulls

topic remove nulls from count qlik sense in App Development

remove nulls from count qlik sense