topic Re: Reference to self Error in Master Measures in QlikView

Reference to self Error in Master Measures

zhaokuifangmm — Tue, 16 Mar 2021 10:28:54 GMT

Hi all,

I have a master measure with the following formula:

If(Present >= 20, 'Good', If(Present >= 10, 'Medium', 'Bad'))

This formula used to work fine. However, when I checked this report I found that this field does not work anymore.

In the edit mode I got the following error message:

Reference to self

As I understood I cannot use the same reference in the else clause. Does anybody knows why it used to work but not now? Is there any other way to write this formula? Many thanks!

Re: Reference to self Error in Master Measures

sfbi — Tue, 16 Mar 2021 19:53:21 GMT

I'm getting the same here in a two condition if measure... never saw this kind of error.

Re: Reference to self Error in Master Measures

harm_dataspark — Wed, 17 Mar 2021 07:33:24 GMT

I'm experiencing the same issue. It looks like you cannot use the same master measure more than once in an expression.

Re: Reference to self Error in Master Measures

sfbi — Wed, 17 Mar 2021 13:42:08 GMT

@harm_dataspark yes... in my case I was using if(MasterMeasure1 > 0 and MasterMeasure1 < 2, x, y)...

I solved writing down the expression it self inside the if statement.