topic Re: Null Value in QlikView

Null Value

Mon, 13 Feb 2017 10:30:52 GMT

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={'*'}

>}Link_Rev)

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

Please help me in this regard.

Thanks

Re: Null Value

sunny_talwar — Mon, 13 Feb 2017 10:33:08 GMT

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

Mon, 13 Feb 2017 10:39:04 GMT

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

sunny_talwar — Mon, 13 Feb 2017 10:40:45 GMT

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

Re: Null Value

Mon, 13 Feb 2017 10:43:35 GMT

i have tried the below one but it is not working

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

Build_type={'old'},

ELF-={'Planung'},

nullcount(St)

>}Link_Rev)

Re: Null Value

sunny_talwar — Mon, 13 Feb 2017 10:45:01 GMT

I meant like this

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

Re: Null Value

Mon, 13 Feb 2017 10:53:42 GMT

Unfortunately it is not working.

Thanks for the support.

I hope you might have some other tips for me.

Re: Null Value

sunny_talwar — Mon, 13 Feb 2017 11:02:17 GMT

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

Re: Null Value

sdmech81 — Mon, 13 Feb 2017 11:03:38 GMT

Try this:

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

Sachin

Re: Null Value

Mon, 13 Feb 2017 11:07:29 GMT

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

Re: Null Value

sdmech81 — Mon, 13 Feb 2017 11:18:24 GMT

What error??

Can u attach Application atleast with limited data?

Re: Null Value

Mon, 13 Feb 2017 11:29:19 GMT

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

But thanks for the support

Re: Null Value

sunny_talwar — Mon, 13 Feb 2017 11:59:44 GMT

See if this link can help you with your confidentiality constraints

Preparing examples for Upload - Reduction and Data Scrambling

Re: Null Value

Mon, 13 Feb 2017 12:04:55 GMT

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

Re: Null Value

sunny_talwar — Mon, 13 Feb 2017 12:10:42 GMT

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