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

How to show KPIs in straight table

Hi,

I have a straight table in qvw like below

SubjectTotalPassPassed by StampPassed by Average
Science250150100
Maths345100245
English50050450
Zoology20012080
Botany40020380

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.

1 Solution

Accepted Solutions
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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

View solution in original post

17 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

In the Expression tree, expand the sub elements by clikcing the plus sign. There is a leaf called Background Color. Select it and enter =green(), =red() or =yellow in the expression field.

Not that these colors may make your numbers unreadable. Use =rgb(R, G, B) to defined lighter colors.

Peter

jerem1234
Specialist II
Specialist II

Yes, Next to each expression click the + sign, and then go to background color. There you can specify a color like red(), yellow(), green(), and if you know the rgb value, rgb(). You can also use expressions here like:

IF([Passed by Stamp] <=50, yellow(), green())

Hope this helps!

Peter_Cammaert
Partner - Champion III
Partner - Champion III

See screenshot:

ColorExpressionCells.jpg

Not applicable
Author

Thanks and if I want to show the images like arrows or Led symbols how can I do this?

ashwanin
Specialist
Specialist

Hi Amela,

As you have 3 different expressions in your straight table : Total Pass, Pass by Stamp and Passed by Average.

So go to the expressions click + sign and go to BackGround Colour , then in Definintion field put = (yellow)

then choose ok,

Same do it for other expressions, change colour name and its ok.

Not applicable
Author

Thanks. If I want to show images I just Used below but it is showing error

if([Passed by Stamp] <=50 'qmem://<bundled>/BuiltIn/led_g.png' , 'qmem://<bundled>/BuiltIn/led_g.png')

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Put a comma behing the logical expression (after the value 50)

Peter

Not applicable
Author

I tried but same error is showing

Not applicable
Author

Do I need to change any thing else here?Please let me know