<?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 How to achieve Amount and Count format Pattern on same chart in App Development</title>
    <link>https://community.qlik.com/t5/App-Development/How-to-achieve-Amount-and-Count-format-Pattern-on-same-chart/m-p/1361984#M30577</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;Hi,&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;I'm using an variable which as Count/Amount options, &lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;On click of count the data of the chart should be displayed in number format and on click of amount the data should be displayed in money format,based on number of digits the money format should change to cr(crore),l(lakh),..automatically ,&lt;/SPAN&gt;&amp;nbsp; but the format pattern does not change accordingly. &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;Below is the expression used in the chart: &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;sum(if(vRF='C',RFCount, &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;if(vRF='A',RFValue))) &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;vRF is the variable name used for selection of amount or count option, C-Count and A-Amount. &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;For reference Pfa .qvf file&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;Thanks and Regards,&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;Deepika&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Tue, 25 Jul 2017 06:24:04 GMT</pubDate>
    <dc:creator>deepikavijayan</dc:creator>
    <dc:date>2017-07-25T06:24:04Z</dc:date>
    <item>
      <title>How to achieve Amount and Count format Pattern on same chart</title>
      <link>https://community.qlik.com/t5/App-Development/How-to-achieve-Amount-and-Count-format-Pattern-on-same-chart/m-p/1361984#M30577</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;Hi,&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;I'm using an variable which as Count/Amount options, &lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;On click of count the data of the chart should be displayed in number format and on click of amount the data should be displayed in money format,based on number of digits the money format should change to cr(crore),l(lakh),..automatically ,&lt;/SPAN&gt;&amp;nbsp; but the format pattern does not change accordingly. &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;Below is the expression used in the chart: &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;sum(if(vRF='C',RFCount, &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;if(vRF='A',RFValue))) &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;vRF is the variable name used for selection of amount or count option, C-Count and A-Amount. &lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;For reference Pfa .qvf file&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;Thanks and Regards,&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #737373; font-family: arial, verdana, sans-serif; font-size: 13px;"&gt;Deepika&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 25 Jul 2017 06:24:04 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/How-to-achieve-Amount-and-Count-format-Pattern-on-same-chart/m-p/1361984#M30577</guid>
      <dc:creator>deepikavijayan</dc:creator>
      <dc:date>2017-07-25T06:24:04Z</dc:date>
    </item>
  </channel>
</rss>

