topic Re: Having trouble with dual function when send to excel in QlikView https://community.qlik.com/t5/QlikView/Having-trouble-with-dual-function-when-send-to-excel/m-p/706681#M254654 <HTML><HEAD></HEAD><BODY><P>I think the reason is that qlikview removed the meta-information from these column if you used format-functions and as setting by expression-standard. By trouble with layouts and formatings is it often useful to use separate objects in a hidden sheet to export and print.</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 19 Aug 2014 15:21:16 GMT marcus_sommer 2014-08-19T15:21:16Z Having trouble with dual function when send to excel https://community.qlik.com/t5/QlikView/Having-trouble-with-dual-function-when-send-to-excel/m-p/706680#M254653 <HTML><HEAD></HEAD><BODY><P>Hey guys,</P><P>I'm having a problem with a chart on my qlikview dashboard. I've read on here that when using a dual function, Send to excel will use the number portion of the Dual function for the export.</P><P></P><P>This is not working for me. It is using the text portion of the dual function.</P><P><BR />I have a need to represent data in my dashboard in millions or thousands but on export I want it to be the full number.</P><P></P><P>I've included a sample QVW file which has some data.</P><P></P><P>Not sure what the issue is.</P></BODY></HTML> Tue, 19 Aug 2014 15:02:21 GMT https://community.qlik.com/t5/QlikView/Having-trouble-with-dual-function-when-send-to-excel/m-p/706680#M254653 2014-08-19T15:02:21Z Re: Having trouble with dual function when send to excel https://community.qlik.com/t5/QlikView/Having-trouble-with-dual-function-when-send-to-excel/m-p/706681#M254654 <HTML><HEAD></HEAD><BODY><P>I think the reason is that qlikview removed the meta-information from these column if you used format-functions and as setting by expression-standard. By trouble with layouts and formatings is it often useful to use separate objects in a hidden sheet to export and print.</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 19 Aug 2014 15:21:16 GMT https://community.qlik.com/t5/QlikView/Having-trouble-with-dual-function-when-send-to-excel/m-p/706681#M254654 marcus_sommer 2014-08-19T15:21:16Z