topic Re: How to show KPIs in straight table in QlikView

How to show KPIs in straight table

Thu, 13 Feb 2014 13:56:05 GMT

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.

Re: How to show KPIs in straight table

Peter_Cammaert — Thu, 13 Feb 2014 14:03:44 GMT

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

Re: How to show KPIs in straight table

jerem1234 — Thu, 13 Feb 2014 14:03:47 GMT

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!

Re: How to show KPIs in straight table

Peter_Cammaert — Thu, 13 Feb 2014 14:07:18 GMT

See screenshot:

Re: How to show KPIs in straight table

Thu, 13 Feb 2014 14:14:16 GMT

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

Re: How to show KPIs in straight table

ashwanin — Thu, 13 Feb 2014 14:16:20 GMT

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.

Re: How to show KPIs in straight table

Thu, 13 Feb 2014 14:17:57 GMT

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')

Re: How to show KPIs in straight table

Peter_Cammaert — Thu, 13 Feb 2014 14:18:56 GMT

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

Peter

Re: How to show KPIs in straight table

Thu, 13 Feb 2014 14:23:00 GMT

I tried but same error is showing

Re: How to show KPIs in straight table

Thu, 13 Feb 2014 14:32:53 GMT

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

Re: How to show KPIs in straight table

Peter_Cammaert — Thu, 13 Feb 2014 14:35:08 GMT

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

Re: How to show KPIs in straight table

Thu, 13 Feb 2014 14:39:14 GMT

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

Re: How to show KPIs in straight table

Peter_Cammaert — Thu, 13 Feb 2014 14:41:56 GMT

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!

Re: How to show KPIs in straight table

Thu, 13 Feb 2014 14:45:53 GMT

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

Re: How to show KPIs in straight table

Peter_Cammaert — Thu, 13 Feb 2014 14:51:05 GMT

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

Re: How to show KPIs in straight table

Thu, 13 Feb 2014 14:51:56 GMT

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

Re: Re: How to show KPIs in straight table

Peter_Cammaert — Thu, 13 Feb 2014 14:58:37 GMT

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

Re: How to show KPIs in straight table

Thu, 13 Feb 2014 15:03:27 GMT

Thanks very much you are right!