Reg Data Filter in Qlik Sense

[Vishnu]

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

[devarasu07]

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

[Vishnu]

Hi Dev

Here I need to show count of null values of a country

[Vishnu]

Can you share your contact like wtsapp in email

Vishnuqlikview03@gmail.com

[devarasu07]

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