How to show KPIs in straight table

[#1]

Hi,

I have a straight table in qvw like below

Subject	TotalPass	Passed by Stamp	Passed by Average
Science	250	150	100
Maths	345	100	245
English	500	50	450
Zoology	200	120	80
Botany	400	20	380

I would need to show KPIs with colours. I,e I should show Passed by Stamp as Red and Passed by Average as Yellow and TotalPass as Green.

Is it possible to do this?

In above Subject is Dimension and TotalPass, Passed by Stamp , Passed by Average are Expressions.

Thanks in advance.

[Peter_Cammaert]

Can you post a screenshot of your Edit Expression Dialog box? If there is an error in your image expression, it should shown where by way of zig-zag lines.

Peter

[#3]

Thanks and instead of arrows or Led symbols it is showing like attached.

[Peter_Cammaert]

I didn't find any attachment.

BTW In Properties->Expressions->Display Options, have you set Representation to Image? Otherwise you'll get plain text instead of nice arrows.

Peter

Edit: indeed, that is what you should do to obtain graphics instead of plain text. But that's normal behavior, not just an error!

[#5]

Thanks . Yes I changed to Image. Now after changing to image it is shwoing Blanks under KPI

[Peter_Cammaert]

Did you put this expression-with-leg-images in the definition field of the expression with label [Passed By Stamp]? In that case it will refer to itself.

Peter

[#7]

Sorry I am not able to get this. Could you let me know a bit more clear

[Peter_Cammaert · Accepted solution]

You may need to set Display Options->Image Formatting to "Keep Aspect" as well. But now I'm just guessing what may be wrong, as I don't have all the details of your situation.

See attachment for a working example.

Good luck,

Peter

[#9]

Thanks very much you are right!