topic Re: How to set null condition in set anslysis? in QlikView

How to set null condition in set anslysis?

alex_stone — Wed, 16 Mar 2016 01:26:08 GMT

Currently, we want to add one condition that close_date = null in set analysis, how to reach that?

e.g. sum({< close_date={null()} >} total)

But, this expression cannot work.

What can I do if want to add null condition in set analysis? Thanks.

sunny_talwar — Wed, 16 Mar 2016 01:27:54 GMT

May be this:

=Sum({<close_date = {"=Len(Trim(close_date)) = 0"}>}total)

=Sum({<close_date = {"=IsNull(close_date)"}>}total)

=Sum({<close_date -= {'*'}>}total)

jagan — Wed, 16 Mar 2016 01:45:42 GMT

Hi,

Try like this

sum({< close_date-={'*'} >} total)

Hope this helps you.

Regards,

Jagan.

avinashelite — Wed, 16 Mar 2016 06:05:06 GMT

try like this

=Sum({<close_date = {"=if(Len(Trim(close_date)) = 0,close_date)"}>}total)

=Sum({<close_date -= {'*'}>}total)

Chanty4u — Wed, 16 Mar 2016 06:08:16 GMT

for more,

=sum({<close_date={'Null'}>}total)

alex_stone — Sat, 19 Mar 2016 06:40:39 GMT

Thank you for your replay, let me try it. Thanks again.