Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to get KPI lights in excel sheet when sending data to excel from access point? URGENT HELP PLEASE

Hi,

I have straight table with KPI as in attached KPIs png. when my user sending this information to excel he/she can not able to see lights under KPI column in excel sheet as it is showing blank which is in attached excel png. Please can anyone let me know how to set this to see the lights in excel also.

Thanks.

1 Solution

Accepted Solutions
Not applicable
Author

PFA a sample.

Hope it helps!

View solution in original post

10 Replies
Not applicable
Author

Hi,

can anyone solve this please? Has anyone got this situation. If so please share

Not applicable
Author

If the data(KPIs) is not showing as images in excel then what is the use of KPI? Please any help?

Not applicable
Author

Please cna nayone let me know whether it is possible or not? otherwise I will close the discussion thread Please

Not applicable
Author

Hi Amelia,

We have used these traffic light gauges in our charts.But since they can't be exported to excel, so we have assigned a numeric value to them so when exported to excel, the values will be shown and not blanks.

This approach might be of help.

Not applicable
Author

Thanks and how you assign values to see in excel. Please can you share?

manojkulkarni
Partner - Specialist II
Partner - Specialist II

Instead of using LED lights, better use background colour on basis of expression.

Bill_Britt
Former Employee
Former Employee

Hi,

You can not export images to excel. This option isn't available with BIff export.

Bill

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Not applicable
Author

PFA a sample.

Hope it helps!

Not applicable
Author

Thanks and this is good.