export traffic lights to excel with a macro

Fri, 20 Apr 2012 21:35:30 GMT

Hi all,

I need to export to excel a table which has traffic lights as one of the columns. I haven't found a possibility to do so with standard QV functionality. My only option now is to write a macro that would apply a custom format in excel so that the numbers look like traffic lights.

But I have problems writing a macro.

Attached is a QV file with the table that needs to be exported and a macro that exports it to excel. The format that needs to be applied is ##,##0.0,,;[Red](#,##0.0,,)

This should make it look like this:

I would really appreciate if anyone could help me with that.

Thank you!

topic export traffic lights to excel with a macro in QlikView

export traffic lights to excel with a macro