Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

export traffic lights to excel with a macro

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:

trafficlights.bmp

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

Thank you!

0 Replies