14 Replies Latest reply: Feb 13, 2017 7:10 AM by Sunny Talwar

# Null Value

Dear All,

I am usnig the set analysis and now I am encountering a null problem.

I have multiple search "Count" and also wants to count null values.

count(distinct{\$<KomDaten={"*ABC*"},

Build_type={'old'},

ELF-={'Planung'},

isnull St={'*'}

I am trying to use ther Isnull function but the result is always ZERO.

Thanks

• ###### Re: Null Value

Are you trying to ignore selection in St field? May be try this:

Count(DISTINCT {\$<KomDaten={"*ABC*"}, Build_type={'old'}, ELF-={'Planung'}, St= >}Link_Rev)

• ###### Re: Null Value

Thanks for the quick response but it is not working.

Actually I want to count all the blanks in "ST" but unfortunately the simplest part cannot be solved

• ###### Re: Null Value

May be NullCount(ST) will count Nulls in ST?

• ###### Re: Null Value

i have tried the below one but it is not working

count(distinct{\$<KomDaten={"*ABC*"},

Build_type={'old'},

ELF-={'Planung'},

nullcount(St)

• ###### Re: Null Value

I meant like this

Count(DISTINCT {\$<KomDaten={"*ABC*"}, Build_type={'old'}, ELF-={'Planung'}>}Link_Rev) + NullCount(St)

• ###### Re: Null Value

Unfortunately it is not working.

Thanks for the support.

I hope you might have some other tips for me.

• ###### Re: Null Value

Do you have a sample you can share to help you better?

• ###### Re: Null Value

Try this:

Count(DISTINCT {\$<KomDaten={"*ABC*"}, Build_type={'old'}, ELF-={'Planung'}, len(St)=0 >}Link_Rev)

Sachin

• ###### Re: Null Value

It is also not helping me out as the expression is showing error.

• ###### Re: Null Value

What error??

Can u attach Application atleast with limited data?

• ###### Re: Null Value

the data is sensetive thats why i am not in a position to share anything. Sorry

But thanks for the support

• ###### Re: Null Value

Preparing examples for Upload - Reduction and Data Scrambling

• ###### Re: Null Value

I am using Qlik Sense and I dont think so it contains such a feature.

• ###### Re: Null Value

Yes, you might be right. The last thing I can suggest is that we are not looking for your actual application. We just want to understand what you have. and to help us understand, all you need is to mock up some data and share it with us and explain what is that you desire to get out of it. If that is something you are not able to do, then I am afraid a lot of us won't be able to offer much help.

Best,

Sunny