Re: Using master measures in IF statement. - Qlik Community

Architect · ‎2022-10-31

I have 3 master measures.

M_total,

M_app,

M_max.

Now we have to create an if statement that will give us colour output.

If M_total less than M_app colour is green .

And if M_total more than M_app colour is red .

What would be the code?

MendyS · ‎2022-10-31

try -

IF(M_total<M_app ,Green(),Red())

what do you want to do if M_total is equal to M_app?

Architect · ‎2022-10-31

Not working.

These are measures, having wrong op

MendyS · ‎2022-10-31

OK

can you send a screenshot of the error that you got?

Using master measures in IF statement.