topic Re: Traffic object inside text object in QlikView

Traffic object inside text object

Anonymous — Tue, 30 May 2017 12:39:47 GMT

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.

Re: Traffic object inside text object

micheledenardi — Tue, 30 May 2017 12:52:29 GMT

There is no possibility to do this using QlikView.

Re: Traffic object inside text object

felipedl — Tue, 30 May 2017 12:53:10 GMT

Hi Jacek,

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

Regards,

Felipe.

Re: Traffic object inside text object

Anonymous — Tue, 30 May 2017 14:19:07 GMT

Hello Felip,

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

sample

Regards

Jacek.

Re: Traffic object inside text object

vishsaggi — Tue, 30 May 2017 14:38:30 GMT

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

Re: Traffic object inside text object

felipedl — Tue, 30 May 2017 14:40:06 GMT

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.

Re: Traffic object inside text object

Anonymous — Tue, 30 May 2017 14:41:36 GMT

Hello Friend,

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

Regards

Jacek.

Re: Traffic object inside text object

Anil_Babu_Samineni — Tue, 30 May 2017 14:47:43 GMT

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

Re: Traffic object inside text object

vishsaggi — Tue, 30 May 2017 15:16:59 GMT

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