topic Re: set analysis in QlikView

set analysis

Tue, 04 Mar 2014 09:20:51 GMT

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

Regards

Mahesh

Tue, 04 Mar 2014 09:22:40 GMT

could you please give some more information

regards,

Tue, 04 Mar 2014 09:24:47 GMT

share your QVW I will show you

jonathandienst — Tue, 04 Mar 2014 09:25:02 GMT

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

HTH

Jonathan

Tue, 04 Mar 2014 09:25:08 GMT

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

Tue, 04 Mar 2014 09:26:39 GMT

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

er_mohit — Tue, 04 Mar 2014 09:27:21 GMT

try this

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

or try this

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

Tue, 04 Mar 2014 09:29:02 GMT

This might help

Tue, 04 Mar 2014 11:48:55 GMT

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

Tue, 04 Mar 2014 12:21:51 GMT

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

regards,