topic Re: Adding Null value dimensions in QlikView

Adding Null value dimensions

zagzebski — Mon, 17 Dec 2012 22:02:55 GMT

I have a field called Group Size with values L, S, and M. however sometimes there is a null value in this field but there are $'s that need to be account for..example:

Group A , Size L = $100

Group B, Size M = $200

Group C, Size S = $300

Group D, Size (null) = $400

What would the set analysis be for Size = L + S + Null Values in an object?

Currently I have this part in the expression which works fine: = {'L'}+{'S'}

but don't know how to add the null portion.

Re: Adding Null value dimensions

MayilVahanan — Mon, 17 Dec 2012 22:23:10 GMT

So you want to exclude the M value correct?

If so, you can try like this

Sum({<Size -={'M'}>}Sales)

Hope it helps

Re: Adding Null value dimensions

zagzebski — Tue, 18 Dec 2012 14:39:18 GMT

Thanks for the response. I probably oversimplified.

thre is actually many "Size" values. How do I get only:

(1) "L"

(2) "S"

(3) null values

Re: Adding Null value dimensions

MayilVahanan — Tue, 18 Dec 2012 17:25:38 GMT

Try like this

sum({<Size -={'*'}> + <Size={'L','S'}>} Sales)

hope it helps

Re: Adding Null value dimensions

zagzebski — Tue, 18 Dec 2012 17:29:08 GMT

Thanks.

can you explain how this accounts for null values: Size -={'*'}

Re: Adding Null value dimensions

MayilVahanan — Tue, 18 Dec 2012 17:33:19 GMT

* represents all values in the field

- = exclude the values.

so, size-={'*'} exclude all values in the field, it include only null values.

hope you can understand now.

Re: Adding Null value dimensions

zagzebski — Tue, 18 Dec 2012 17:44:55 GMT

So simple!. Thanks so much...