<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: Format in Expression in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/Format-in-Expression/m-p/579691#M679759</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Omar,&lt;/P&gt;&lt;P&gt;using the num() function within a expresion doesn't have any effect on excel-export.&lt;/P&gt;&lt;P&gt;If you can't use the format settings from the number-tab of chart-properties:&lt;/P&gt;&lt;P&gt;text(num(.....)) will help on excel-exports as a workaround&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;HtH&lt;/P&gt;&lt;P&gt;Roland&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 15 Apr 2014 14:26:37 GMT</pubDate>
    <dc:creator />
    <dc:date>2014-04-15T14:26:37Z</dc:date>
    <item>
      <title>Format in Expression</title>
      <link>https://community.qlik.com/t5/QlikView/Format-in-Expression/m-p/579690#M679758</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi everyone&lt;/P&gt;&lt;P&gt;I have the next format in my expression this way:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1.- first declare a variable&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;2.- I calling that variable in my expression to get the format that I need&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;The problem is just when I export the information to excel from a graphic or table doesn't appear the format and the symbols that I need.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;can you help&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;1.-&lt;/P&gt;&lt;P&gt;&lt;IMG alt="Variable.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/57341_Variable.jpg" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt; 2.-&lt;/P&gt;&lt;P&gt;&lt;IMG alt="expression.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/57342_expression.jpg" style="width: 620px; height: 548px;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;this is my graphic;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="grafica.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/57343_grafica.jpg" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;when I export the information doesn't appear the symbols is different&amp;nbsp; the format&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG alt="tabla.jpg" class="jive-image" src="https://community.qlik.com/legacyfs/online/57344_tabla.jpg" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Can you help plis?&lt;BR /&gt; &lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 15 Apr 2014 13:56:56 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Format-in-Expression/m-p/579690#M679758</guid>
      <dc:creator />
      <dc:date>2014-04-15T13:56:56Z</dc:date>
    </item>
    <item>
      <title>Re: Format in Expression</title>
      <link>https://community.qlik.com/t5/QlikView/Format-in-Expression/m-p/579691#M679759</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi Omar,&lt;/P&gt;&lt;P&gt;using the num() function within a expresion doesn't have any effect on excel-export.&lt;/P&gt;&lt;P&gt;If you can't use the format settings from the number-tab of chart-properties:&lt;/P&gt;&lt;P&gt;text(num(.....)) will help on excel-exports as a workaround&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;HtH&lt;/P&gt;&lt;P&gt;Roland&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 15 Apr 2014 14:26:37 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/Format-in-Expression/m-p/579691#M679759</guid>
      <dc:creator />
      <dc:date>2014-04-15T14:26:37Z</dc:date>
    </item>
  </channel>
</rss>

