topic Background Color arrangement in QlikView

Background Color arrangement

Learnerr — Wed, 27 Jul 2022 11:20:42 GMT

Hi experts,

I would like arrange the background color of my dimension. I need to say my If clause to look for 2 fields but i cannot write the proper way of it. How can i arrange my if clause please?

=if(Exclusive_Tanim='STRW-DÜZ and Exclusive_Tanim=STRW-DEKOR', rgb(255, 0, 0),rgb(0, 128, 0) )

Have a nice day!

Re: Background Color arrangement

marcus_sommer — Wed, 27 Jul 2022 15:25:06 GMT

Syntax and logic aren't quite right. Try it instead with:

=if(match(Exclusive_Tanim, 'STRW-DÜZ', 'STRW-DEKOR'), rgb(255, 0, 0),rgb(0, 128, 0) )

- Marcus

Re: Background Color arrangement

Learnerr — Thu, 28 Jul 2022 14:02:33 GMT

Thanks,it works.

Have a nice day!