topic Re: Transforming text in image inside data table in QlikView

Transforming text in image inside data table

Tue, 20 Oct 2015 12:30:19 GMT

Hello everyone,

I am new on QlikView and i am trying to make a table with large data more interesting.

My table has a field called "Status", with two distinct values: "Green" and "Red".

My idea is to display this information with colors, and not in text, as shown below:

Anyone knows if it is possible to do that on QlikView?

Regards,

Re: Transforming text in image inside data table

sunny_talwar — Tue, 20 Oct 2015 12:31:55 GMT

It is possible to do this. Check this link out: Display images in straight table‌ and this: Images as column data in straight table

Re: Transforming text in image inside data table

Anonymous — Tue, 20 Oct 2015 12:33:20 GMT

On the Expressions tab of your Chart Properties set the expression Display Options to have a Representation of Taffic Light Gunge, and set the Gauge Setting appropriately for your needs.

Re: Transforming text in image inside data table

Anonymous — Tue, 20 Oct 2015 12:33:41 GMT

you can define the representation of your Expression as Traffic Light Gauge and define setings

Re: Transforming text in image inside data table

sunny_talwar — Tue, 20 Oct 2015 12:33:50 GMT

and to load your own images, check this out: Bundle Info Load

Re: Transforming text in image inside data table

Tue, 20 Oct 2015 16:18:31 GMT

Hello,

Thanks you all for the tips.

I have made the Traffic Light Gauge as you suggested, and now i have a new problem:

All values from the field "Status" that are NULL, it shows the green light, as you can see below:

I would not like to display the green light when the value is null.

Someone, please can help me to solve this?

Regards,

Re: Transforming text in image inside data table

sunny_talwar — Tue, 20 Oct 2015 16:20:57 GMT

If you want to not show green or red, you can try this:

If([Status Mes] > 0, YourExpressionForTrafficLightGauge)

Re: Transforming text in image inside data table

Tue, 20 Oct 2015 16:36:55 GMT

You can create custom column in your script as expression given below and then you can use trafficlight min and max.

if(Status='Green',1,if(Status='Red',0,Null())) as StatusFlag