Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Traffic object inside text object

Hello Qliks,

I have currently table like here:

DEV_1.png

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

DEV_2.png

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.

8 Replies
micheledenardi
Specialist II
Specialist II

There is no possibility to do this using QlikView.

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
felipedl
Partner - Specialist III
Partner - Specialist III

Hi Jacek,

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

Sample.png

Regards,

Felipe.

Anonymous
Not applicable
Author

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
Champion III
Champion III

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

Capture.PNG

felipedl
Partner - Specialist III
Partner - Specialist III

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.Sample.png

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
Not applicable
Author

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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
vishsaggi
Champion III
Champion III

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