Traffic object inside text object

[Anonymous]

Hello Qliks,

I have currently table like here:

I want to add inside text object about e.g risk information, something like traffic lights to achieve that result:

Traffic lights color depend on Risk column.

If is not possible please give me some proposition, how I can solve it.

Thank you.

Regards

Jacek.

[micheledenardi]

There is no possibility to do this using QlikView.

[felipedl]

Hi Jacek,

You could condition the background of the cell with an expression to get something like this:

Regards,

Felipe.

[Anonymous]

Hello Felip,

So maybe other question, it is possible to format text but just half of text in one field? Like:

sample

Regards

Jacek.

[vishsaggi]

Can using a separate column and use only the expression with image for that column. Will that work? Something like this?

[felipedl]

Jacek,

I don't think there's an option to partially fill the text, for what you need, you could use both conditions (background and text) to achieve what you want with your indicators.

Another solution would be to create another column with a char value that has a symbol (see the attached QVF file) and change this color for the traffic light aspect you want.

For possible char values, you can check this post on the community:

How to find a number for a char: chr() and ord() functions

Felipe.

[Anonymous]

Hello Friend,

Unfortunately, I can't add the additional column, because it reduces visibility.

Regards

Jacek.

[Anil_Babu_Samineni]

There is no way to achieve this without 2 columns. Why not 2 columns and we can manipulate borders by help of Custom Format Cell

[vishsaggi]

Unfortunately field cannot take text and image at the same time. Just work around would be adding a different column and customformat.