topic How to get KPI lights in excel sheet when sending data to excel from access point? URGENT HELP PLEASE in QlikView https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564359#M1111717 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 25 Feb 2014 09:46:00 GMT 2014-02-25T09:46:00Z How to get KPI lights in excel sheet when sending data to excel from access point? URGENT HELP PLEASE https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564359#M1111717 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 25 Feb 2014 09:46:00 GMT https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564359#M1111717 2014-02-25T09:46:00Z Re: How to get KPI lights in excel sheet when sending data to excel from access point? https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564360#M1111719 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>can anyone solve this please? Has anyone got this situation. If so please share </P></BODY></HTML> Tue, 25 Feb 2014 10:04:59 GMT https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564360#M1111719 2014-02-25T10:04:59Z Re: How to get KPI lights in excel sheet when sending data to excel from access point? URGENT HELP PLEASE https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564361#M1111721 <HTML><HEAD></HEAD><BODY><P>If the data(KPIs) is not showing as images in excel then what is the use of KPI? Please any help?</P></BODY></HTML> Tue, 25 Feb 2014 10:49:45 GMT https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564361#M1111721 2014-02-25T10:49:45Z Re: How to get KPI lights in excel sheet when sending data to excel from access point? URGENT HELP PLEASE https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564362#M1111723 <HTML><HEAD></HEAD><BODY><P>Please cna nayone let me know whether it is possible or not? otherwise I will close the discussion thread Please<IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Tue, 25 Feb 2014 11:10:56 GMT https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564362#M1111723 2014-02-25T11:10:56Z Re: How to get KPI lights in excel sheet when sending data to excel from access point? URGENT HELP PLEASE https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564363#M1111726 <HTML><HEAD></HEAD><BODY><P>Hi Amelia,</P><P></P><P>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.</P><P></P><P>This approach might be of help.</P></BODY></HTML> Tue, 25 Feb 2014 11:18:31 GMT https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564363#M1111726 2014-02-25T11:18:31Z Re: How to get KPI lights in excel sheet when sending data to excel from access point? URGENT HELP PLEASE https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564364#M1111728 <HTML><HEAD></HEAD><BODY><P>Thanks and how you assign values to see in excel. Please can you share?</P></BODY></HTML> Tue, 25 Feb 2014 11:21:00 GMT https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564364#M1111728 2014-02-25T11:21:00Z Re: How to get KPI lights in excel sheet when sending data to excel from access point? URGENT HELP PLEASE https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564365#M1111730 <HTML><HEAD></HEAD><BODY><P>Instead of using LED lights, better use background colour on basis of expression.</P></BODY></HTML> Tue, 25 Feb 2014 11:30:34 GMT https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564365#M1111730 manojkulkarni 2014-02-25T11:30:34Z Re: How to get KPI lights in excel sheet when sending data to excel from access point? URGENT HELP PLEASE https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564366#M1111731 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>You can not export images to excel. This option isn't available with BIff export.</P><P></P><P>Bill</P></BODY></HTML> Tue, 25 Feb 2014 11:36:41 GMT https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564366#M1111731 Bill_Britt 2014-02-25T11:36:41Z Re: Re: How to get KPI lights in excel sheet when sending data to excel from access point? URGENT HELP PLEASE https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564367#M1111733 <HTML><HEAD></HEAD><BODY><P>PFA a sample.</P><P>Hope it helps!</P></BODY></HTML> Tue, 25 Feb 2014 11:38:28 GMT https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564367#M1111733 2014-02-25T11:38:28Z Re: How to get KPI lights in excel sheet when sending data to excel from access point? URGENT HELP PLEASE https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564368#M1111735 <HTML><HEAD></HEAD><BODY><P>Thanks and this is good.</P></BODY></HTML> Tue, 25 Feb 2014 11:42:06 GMT https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564368#M1111735 2014-02-25T11:42:06Z Re: How to get KPI lights in excel sheet when sending data to excel from access point? URGENT HELP PLEASE https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564369#M1111736 <HTML><HEAD></HEAD><BODY><P>I have used the background colour I just used in my expression as below</P><P></P><P>Count(DISTINCT(IF(ISNULL(Date), ID ,RED())))</P><P></P><P>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?</P></BODY></HTML> Tue, 25 Feb 2014 11:44:51 GMT https://community.qlik.com/t5/QlikView/How-to-get-KPI-lights-in-excel-sheet-when-sending-data-to-excel/m-p/564369#M1111736 2014-02-25T11:44:51Z