topic Combine two expressions, even though one is missing values in dimension in QlikView

Combine two expressions, even though one is missing values in dimension

Tue, 12 Sep 2017 09:26:10 GMT

Hello all,

I have a small and stupid question regarding expressions.

As you can see on screenshot, I have two expressions: Exp01 and Exp02

For Exp01 I have all values in dimensions, and for second one I am missing location.

I would like to have a Exp03 which will multiply Exp01 and Exp02, but it returns 0;

Example values:

Exp01 Exp02 Exp03

1 15 15

0.5 8 4

0.33 9 3

In this case that I am having, I would get 0, since there are missing info for Exp02

Thank you

Re: Combine two expressions, even though one is missing values in dimension

shraddha_g — Tue, 12 Sep 2017 09:34:38 GMT

What you have written in Expression?

Re: Combine two expressions, even though one is missing values in dimension

Tue, 12 Sep 2017 09:36:55 GMT

Exp01

(Sum(Field01) / Sum(TOTAL < Col02, Col01> Field01) )

Exp02:

sum(Field02)

Re: Combine two expressions, even though one is missing values in dimension

shraddha_g — Tue, 12 Sep 2017 09:37:46 GMT

Try

Column(1)*Column(2)

Re: Combine two expressions, even though one is missing values in dimension

swuehl — Tue, 12 Sep 2017 09:40:02 GMT

What about using

Sum(Total<Col02, Col01> Field02)

as second expression?

Re: Combine two expressions, even though one is missing values in dimension

Tue, 12 Sep 2017 09:40:06 GMT

Please check the screenshot, since it will return on all rows 0.

Re: Combine two expressions, even though one is missing values in dimension

Peter_Cammaert — Tue, 12 Sep 2017 09:42:52 GMT

Exp02 seems to return values, even when a Dimension contains a NULL. No problem, for Exp03 you can try recovering the calculations already done for Exp01 and Exp02 by simply referring to their Labels in your third expression. Like this:

= Exp01 * Exp02

The expression syntax checker will color the expression names blue if it recognizes them.

Note that in an expression you can only refer to other expressions in the same object. You cannot use Dimension labels, but you can use Dimension field names of course.