Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jaisaiqlik
New Contributor

Reg Data Filter in Qlik Sense

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

4 Replies
devarasu07
Honored Contributor II

Re: Reg Data Filter 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

jaisaiqlik
New Contributor

Re: Reg Data Filter in Qlik Sense

Hi Dev

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


jaisaiqlik
New Contributor

Re: Reg Data Filter in Qlik Sense

Can you share your contact like wtsapp in email


Vishnuqlikview03@gmail.com

devarasu07
Honored Contributor II

Re: Reg Data Filter in Qlik Sense

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

Community Browser