topic Re: Traffic light gauge in QlikView

Traffic light gauge

Wed, 09 Jul 2014 19:49:28 GMT

I need to list tasks and the status of tasks in a table. the status of each task is either complete or not complete.

I want to have the traffic light gauge in a table next to the list of each task. if its complete it should be green if its not complete it should be red

thanks!

Re: Traffic light gauge

maxgro — Wed, 09 Jul 2014 19:54:42 GMT

in your qlikview installation folder (mine is C:\Program Files\QlikView\Examples\Documents), search for Data Visualization.qvw

You find in tab KPI a traffic light gauge, just copy it and adapt to your requirement

Re: Traffic light gauge

Wed, 09 Jul 2014 20:14:04 GMT

Hi.

I think that in this case, the easiest solution is to use tab "Visual Cues" in Chart Properties. I prefer to work with numbers in this situation, so you can add new field if the "status field" is text. You can try with ApplyMap or IF functions to insert numbers for example 0 - Not Complete 1 - Complete , and 2 - Others (Errors) . This will help you to clean your database.

This is solution for Pivot or Straight Tables but there are most useful in this cases when you have a lot of orders and invoices and you want know what is the status.

Re: Traffic light gauge

Wed, 09 Jul 2014 20:29:45 GMT

This is very helpful thanks but can you be more specific on how to "work with numbers in this situation" I am new to qlikview and I don't know how to use/find applymap or if functions.

Thanks!

Re: Traffic light gauge

Wed, 09 Jul 2014 21:20:35 GMT

Ok.

I mean to create new field in the script , the script has to be something like that: :

LOAD

........

Status,

IF (Status = 'NonComplete' , 0, IF(Status = 'Complete', 1, 2 )) as NewField

........

FROM ABC.qvd

With this "NewField" you can work easier because the numeric fields are better for work in QlikView.

If you have some fields with value 2, you have errors in the database, because this fields are not 'Complete' or 'NotComplete'.

Also, when this field is numeric you can easier use Visual Cues.

You have to add this field like a expression, because Visual Cues work with expression. If doesn't work correctly add sum or the expression has to look like that sum(NewField) . After that everything it will be Ok.

I think this is the best solution for you at this time.

Regards,

Venelin

Re: Traffic light gauge

rwunderlich — Wed, 09 Jul 2014 21:50:08 GMT

If you want numeric values to use in Visual Cues, there is no need define an additional field. Instead create the field as a dual() in the script -- with both a string and numeric value.

For an example of using a Dual() with Visual Cues, see

Qlikview Notes: Performance Tip - Using Dual() and Chart Visual Cues

-Rob

Re: Traffic light gauge

Wed, 09 Jul 2014 21:57:28 GMT

Thank you .

It's look like faster .

Re: Traffic light gauge

rwunderlich — Wed, 09 Jul 2014 22:03:59 GMT

You can add an expression to your chart like:

if(Status='complete', 0, 0.5)

and set the expression representation to Traffic Light. Go into the gauge settings to get it the way you want it.

I think an easier way is to use images using the QV built-in images.

=if(Status='complete

,'qmem://<bundled>/BuiltIn/led_g.png'

,'qmem://<bundled>/BuiltIn/led_r.png'

)

Set the expression representation to "Image" and you are done.

-Rob

Re: Traffic light gauge

Thu, 30 Apr 2015 14:45:39 GMT

Very helpful post!