Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need only 5 countries count of null values to be displayed, I don’t need other count of null values so how should I filter this in Qlik Sense
Hi,
Try like below methods,
Method 1: Best way try to do it at back end using where clause to exclude it
Fact:
LOAD * INLINE [
Country, Sales
India, 4500
Japan, 6500
Malaysia, 700
Singapore, 321324
China, 43445
, 56576
, 32
] where len(Country)>0;
Method2 : enable total mode as sum of rows to show sub total
if(len(Country)>0,Count(Country))
Method 3:
using set analysis at expression
Count( {<Country={"=len(Country)>0"}>}Country)
Thanks,
Deva
Here I need to show count of null values of a country
Hi,
Try like this,
count({$<values={"=isnull(values)"}>} values)
or
count({$<values={"=len(trim(values))=0"}>} values)
or
=NullCount(values)
PS: if still not working try to share your mock source as excel/text format then share your expected output.
Thanks, Deva