set analysis

[#1]

i need set analysis expression for counting null values and not null values.

Regards

Mahesh

[#2]

could you please give some more information

regards,

MT

[#3]

share your QVW I will show you

[jonathandienst · Accepted solution]

Hi

You cannot count nulls using a set expression. Use NullCount() instead. The Count() function already excludes nulls.

HTH

Jonathan

[#5]

hi

count(Distinct {<fieldname={' '}>}fieldname)

[#6]

count(Distinct {<fieldname={'0'}>}fieldname) may also work

[er_mohit]

try this

count({<fieldname={" "}>}value)

or try this

count({<fieldname-={" "}>}value)

[#8]

This might help

QlikView Addict: Handling Nulls in QlikView

[#9]

i have the scenario like i want to count filed values  having null and fields having data in single set analysis expression not through if statement.

Regards

mahesh

[#10]

I think you should look at Jonathan Dienst's answer. He explained to you how it should work.

regards,

MT