"Traffic lights" in a multi table

[#1]

Hi guys,

I saw the fancy demo for project management and was wondering how I can add "traffic lights" to my multitable. See http://us.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs/Axis%20COMPASS%20for%20PPM.qvw&host=De... under the 'Project Analysis' tab for an example. Basically they should just be buttons that tun red, yellow or green depending on the status of my project.

Thank you very much!

Seb

[#2]

Hi Seb,

try to use a (new) expression as an image.

--> chart props --> expression tab

Pull Down "Representation" = Image

Pull Down "Representation" = Keep Aspact (for most of cases)

the defininition of your expression should look like:

if( sum(Amount) > 100000, 'qmem://<bundled>/BuiltIn/arrow_n_g.png','qmem://<bundled>/BuiltIn/arrow_e.png')

HtH

Roland

Note:

Check out the tab "Images" when using the expression editor.

[#3]

Hi Roland,

thanks for the hint! I now get how to work with images but apparently something is wrong with my expression.

Basically, I want to score projects based on cost and budget:

cost < budget -> green light

cost almost near budget -> orange light

cost > budget -> red light

All my data is in two simple columns and the expressions I use is :

if ((cost) > (budget),'qmem://<bundled>/BuiltIn/led_r.png', ['qmem://<bundled>/BuiltIn/led_g.png'])

Could you please tell me where the (obvious) mistake is?

Thanks in advance!

Seb

[#4 · Accepted solution]

Hi Seb,

your expression seems for me to be ok.

But as I don't know your data(-modell), I sent you an app with num(Month) in a chart as an example.

If you need any further help, don't hesitate then to post your own (exam) app.

RR

[#5]

Sic!

Just recognized the square-brackets "[]" in your expression. Forget them.

RR

[#6]

Thanks for your help! I figured out what was wrong: I was in a regular table box instead of straight table chart. In the latter I can adjust the expression / dimension better instead of the table and now it works.

Best regards and my gratitude for your swift replies!

Seb