topic Re: Expression help in QlikView

Expression help

Mon, 07 Apr 2014 10:09:49 GMT

Hello,

I am trying to add an expression to a chart that calculates null values with a particular activity type. I have it working with the expression below:

=nullcount(SALESPARTDESC)

However, I want it to calculate this only for an activity that is an OPD. E.g:

=NULLCOUNT(IF(ACTIVITY_SUB_TYPE = 'OPD', SALESPARTDESC).

This also works but is still calculating the null values for all other activity sub types and not only OPD's. It will only show if I select OPD. (which is frustrating)

Any advice will be greatly received. Thank you.

Re: Expression help

tresB — Mon, 07 Apr 2014 10:13:57 GMT

Try using set analysis, like:

=NULLCOUNT({<ACTIVITY_SUB_TYPE = {'OPD'}>} SALESPARTDESC)

Re: Expression help

Anonymous — Mon, 07 Apr 2014 10:15:03 GMT

Can you post your qvw or the sample data for the same.

It would help us understand your issue on much better way

Regards

Nitin

Re: Expression help

Mon, 07 Apr 2014 10:23:31 GMT

Perfect, thank you!