topic Re: Set Analysis expression in QlikView

Set Analysis expression

vijetas42 — Mon, 14 Sep 2015 14:43:29 GMT

Hi all,

I have 2 values for one of my field like,'ABC' & Null and in set analysis expression i want to calculate value only for Null that is, i want to exclude value 'ABC'

I have wrote expression as sum({<d=P(d)-{'ABC'}>}Sales) but,it's not working.

Please help me out with this expression.

Thanks,

Re: Set Analysis expression

Anonymous — Mon, 14 Sep 2015 14:50:21 GMT

try:

sum({<d-={'ABC'}>}Sales)

Re: Set Analysis expression

Mon, 14 Sep 2015 15:01:03 GMT

hi,

Try with this

1.- Sum(If(IsNull(d),Sales,0))

2.- Sum({$-<d={'*'}>}Sales)

Regards

Re: Set Analysis expression

Gabriel — Mon, 14 Sep 2015 16:50:18 GMT

Hi,

How is the Null generated?

Is it coming from script, as in that's what the data is or result of JOINS?

If that's the case create a Flag for the Null values in the script, this will your UI set analysis.

LOAD

.....

....

,IF(ISNULL(FieldName),1,0) AS %NullField

FROM SourceFile;