topic Extracting file name in QlikView

Extracting file name

Fri, 20 Nov 2020 18:02:30 GMT

Hi.

I need some assistance.

I have a text object where I want to display a number and if the number is less than 100, I would like to show in red, otherwise in blue.

=if([Field_1]<100, Red([Field_1]), blue([Field_1]))

I know this functions red(), blue() is to return a RGB color representation, but it helps me to explain here my problem.

Thanks a lot.

Jorge

swuehl — Mon, 07 May 2012 20:20:33 GMT

I think you can go the text box properties, Font tab and select the Color button.

In the color dialog box, choose a calculated base color and input an expression like

=if([Field_1] < 100, red(), blue() )

Field_1 should give an unambiguous result in the text box to work as expected.

You can set the background color in a similar way on general tab, Color selection button.