Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Vishnu
Contributor II
Contributor II

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
Master II
Master II

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
Contributor II
Contributor II
Author

Hi Dev

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


Vishnu
Contributor II
Contributor II
Author

Can you share your contact like wtsapp in email


Vishnuqlikview03@gmail.com

devarasu07
Master II
Master II

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