<?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 Writing loop at the backend to calculate cost in App Development</title>
    <link>https://community.qlik.com/t5/App-Development/Writing-loop-at-the-backend-to-calculate-cost/m-p/1854658#M70555</link>
    <description>&lt;P&gt;Hi Team,&lt;/P&gt;
&lt;P&gt;I need to calculate the below using loops.&amp;nbsp;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I have a table "Ticket" holding the number of tickets against dates. Need to calculate the cost for the below range of ticket count.&amp;nbsp;&lt;/P&gt;
&lt;TABLE dir="ltr" border="1" cellspacing="0" cellpadding="0"&gt;&lt;COLGROUP&gt;&lt;COL width="132" /&gt;&lt;COL width="237" /&gt;&lt;COL width="195" /&gt;&lt;/COLGROUP&gt;
&lt;TBODY&gt;
&lt;TR&gt;
&lt;TD width="132px" height="47px" data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Min Count of Tickets &amp;quot;}"&gt;Min Count of Tickets&lt;/TD&gt;
&lt;TD width="237px" height="47px" data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Max Count of Tickets&amp;quot;}"&gt;Max Count of Tickets&lt;/TD&gt;
&lt;TD width="195px" height="47px" data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Amount to be charged in dollars&amp;quot;}"&gt;Amount to be charged in dollars&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="132px" height="25px" data-sheets-value="{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:1501}"&gt;1501&lt;/TD&gt;
&lt;TD width="237px" height="25px" data-sheets-value="{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:1750}"&gt;1750&lt;/TD&gt;
&lt;TD width="195px" height="25px" data-sheets-value="{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:500}"&gt;500 $&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="132px" height="25px" data-sheets-value="{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:1751}"&gt;1751&lt;/TD&gt;
&lt;TD width="237px" height="25px" data-sheets-value="{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:2000}"&gt;2000&lt;/TD&gt;
&lt;TD width="195px" height="25px" data-sheets-value="{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:550}"&gt;550 $&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="132px" height="47px"&gt;&amp;nbsp;&lt;/TD&gt;
&lt;TD width="237px" height="47px" data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;for every additonal range of 250 tickets&amp;quot;}"&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;for every additional&amp;nbsp;range of 250 tickets&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="195px" height="47px" data-sheets-value="{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:90}"&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;90 $&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Up to 2000 ticket count, the cost is fixed. Post 2000 ticket count, addition of 250 tickets to be charged 90.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Example:&lt;/P&gt;
&lt;TABLE border="1" width="100%"&gt;
&lt;TBODY&gt;
&lt;TR&gt;
&lt;TD width="50%" height="25px"&gt;Count of ticket&lt;/TD&gt;
&lt;TD width="50%" height="25px"&gt;Price&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="50%"&gt;1569&lt;/TD&gt;
&lt;TD width="50%"&gt;500 $&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="50%" height="25px"&gt;2000&lt;/TD&gt;
&lt;TD width="50%" height="25px"&gt;550 $&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="50%" height="25px"&gt;2249&lt;/TD&gt;
&lt;TD width="50%" height="25px"&gt;550+90 $&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="50%" height="25px"&gt;2500&lt;/TD&gt;
&lt;TD width="50%" height="25px"&gt;550+90+90 $&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Regards,&lt;/P&gt;
&lt;P&gt;Hitha Dhani&lt;/P&gt;</description>
    <pubDate>Tue, 02 Nov 2021 12:55:08 GMT</pubDate>
    <dc:creator>hitha1512</dc:creator>
    <dc:date>2021-11-02T12:55:08Z</dc:date>
    <item>
      <title>Writing loop at the backend to calculate cost</title>
      <link>https://community.qlik.com/t5/App-Development/Writing-loop-at-the-backend-to-calculate-cost/m-p/1854658#M70555</link>
      <description>&lt;P&gt;Hi Team,&lt;/P&gt;
&lt;P&gt;I need to calculate the below using loops.&amp;nbsp;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I have a table "Ticket" holding the number of tickets against dates. Need to calculate the cost for the below range of ticket count.&amp;nbsp;&lt;/P&gt;
&lt;TABLE dir="ltr" border="1" cellspacing="0" cellpadding="0"&gt;&lt;COLGROUP&gt;&lt;COL width="132" /&gt;&lt;COL width="237" /&gt;&lt;COL width="195" /&gt;&lt;/COLGROUP&gt;
&lt;TBODY&gt;
&lt;TR&gt;
&lt;TD width="132px" height="47px" data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Min Count of Tickets &amp;quot;}"&gt;Min Count of Tickets&lt;/TD&gt;
&lt;TD width="237px" height="47px" data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Max Count of Tickets&amp;quot;}"&gt;Max Count of Tickets&lt;/TD&gt;
&lt;TD width="195px" height="47px" data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;Amount to be charged in dollars&amp;quot;}"&gt;Amount to be charged in dollars&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="132px" height="25px" data-sheets-value="{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:1501}"&gt;1501&lt;/TD&gt;
&lt;TD width="237px" height="25px" data-sheets-value="{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:1750}"&gt;1750&lt;/TD&gt;
&lt;TD width="195px" height="25px" data-sheets-value="{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:500}"&gt;500 $&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="132px" height="25px" data-sheets-value="{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:1751}"&gt;1751&lt;/TD&gt;
&lt;TD width="237px" height="25px" data-sheets-value="{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:2000}"&gt;2000&lt;/TD&gt;
&lt;TD width="195px" height="25px" data-sheets-value="{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:550}"&gt;550 $&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="132px" height="47px"&gt;&amp;nbsp;&lt;/TD&gt;
&lt;TD width="237px" height="47px" data-sheets-value="{&amp;quot;1&amp;quot;:2,&amp;quot;2&amp;quot;:&amp;quot;for every additonal range of 250 tickets&amp;quot;}"&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;for every additional&amp;nbsp;range of 250 tickets&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/TD&gt;
&lt;TD width="195px" height="47px" data-sheets-value="{&amp;quot;1&amp;quot;:3,&amp;quot;3&amp;quot;:90}"&gt;&lt;FONT color="#FF0000"&gt;&lt;STRONG&gt;90 $&lt;/STRONG&gt;&lt;/FONT&gt;&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Up to 2000 ticket count, the cost is fixed. Post 2000 ticket count, addition of 250 tickets to be charged 90.&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Example:&lt;/P&gt;
&lt;TABLE border="1" width="100%"&gt;
&lt;TBODY&gt;
&lt;TR&gt;
&lt;TD width="50%" height="25px"&gt;Count of ticket&lt;/TD&gt;
&lt;TD width="50%" height="25px"&gt;Price&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="50%"&gt;1569&lt;/TD&gt;
&lt;TD width="50%"&gt;500 $&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="50%" height="25px"&gt;2000&lt;/TD&gt;
&lt;TD width="50%" height="25px"&gt;550 $&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="50%" height="25px"&gt;2249&lt;/TD&gt;
&lt;TD width="50%" height="25px"&gt;550+90 $&lt;/TD&gt;
&lt;/TR&gt;
&lt;TR&gt;
&lt;TD width="50%" height="25px"&gt;2500&lt;/TD&gt;
&lt;TD width="50%" height="25px"&gt;550+90+90 $&lt;/TD&gt;
&lt;/TR&gt;
&lt;/TBODY&gt;
&lt;/TABLE&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;Regards,&lt;/P&gt;
&lt;P&gt;Hitha Dhani&lt;/P&gt;</description>
      <pubDate>Tue, 02 Nov 2021 12:55:08 GMT</pubDate>
      <guid>https://community.qlik.com/t5/App-Development/Writing-loop-at-the-backend-to-calculate-cost/m-p/1854658#M70555</guid>
      <dc:creator>hitha1512</dc:creator>
      <dc:date>2021-11-02T12:55:08Z</dc:date>
    </item>
  </channel>
</rss>

