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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-02-25 04:46 AM

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.

Preview file
8 KB
Preview file
8 KB
2,082 Views
0 Likes
10 Replies
Not applicable
‎2014-02-25 06:44 AM
Author

In response to manojkulkarni

I have used the background colour I just used in my expression as below

Count(DISTINCT(IF(ISNULL(Date), ID ,RED())))

But I need multiple colours how can I cahnge expression and also instead of RED colour in excel it is showing Dark balck colour. Do I need to chnage anything here?

232 Views
0 Likes