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: 
Not applicable

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

>}Link_Rev)

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

Please help me in this regard.

Thanks

14 Replies
sunny_talwar

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)

Not applicable
Author

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

sunny_talwar

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

Not applicable
Author

i have tried the below one but it is not working

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

Build_type={'old'},

ELF-={'Planung'},

nullcount(St)

>}Link_Rev)

sunny_talwar

I meant like this

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

Not applicable
Author

Unfortunately it is not working.

Thanks for the support.

I hope you might have some other tips for me.

sunny_talwar

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

sdmech81
Specialist
Specialist

Try this:

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

Sachin

Not applicable
Author

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