topic Conditional formatting in QlikView

Conditional formatting

Sun, 09 Mar 2014 07:37:38 GMT

I want to use a route map for a transport system and show the value of say ticket sales at each stop.

I planned on using a text box for each stop (maybe just add a picture of a dot to the text box?)

I wanted the text box/ picture of the dot to be formatted in different colors depending on the value.

Rather than enter absolute values to the text box i wanted them to just change color as they do in Excel ie the highest value say dark red and the lowest a very pale red

Any ideas?

Re: Conditional formatting

its_anandrjs — Sun, 09 Mar 2014 08:00:49 GMT

Hi,

Can you provide any sample of the excel file it will better but i thing you can use .selection count or the images.

HTH

Thanks & Regards

Re: Conditional formatting

Peter_Cammaert — Sun, 09 Mar 2014 10:16:02 GMT

Text in text boxes has a color button in Properties->Font. If you open the corresponding dialog, you will find a Base Color area on the right. Select "Calculated" instead of fixed, and enter an expression that results in a variable RGB value depending on the value of the data point. Use rgb(), colormix1() and colormix2() functions and your original datapoint expression to present a dynamic color for each route point.

There is a great tool for such things if you're not familiar with the colormix functions. In the above "Calculated" expression field, open the Edit Expression dialog (press the gray "..." button) and from the File menu, select Colormix Wizard...

Good luck,

Peter

Re: Conditional formatting

Anonymous — Sun, 09 Mar 2014 12:53:04 GMT

Text box properties goto font tab

select color - base color (conditional) - expression.

if(Year>2009,Green(),Red())

Will give the desired output

Please see attached

Hope this helps