topic Re: how to write script for Aggregate in QlikView https://community.qlik.com/t5/QlikView/how-to-write-script-for-Aggregate/m-p/1453278#M434724 <HTML><HEAD></HEAD><BODY><P>Are you opening this thread or are you viewing it from the inbox? Inbox view doesn't show the option to select correct answer. Try clicking here to see if you see the option to mark correct answer</P><P><A href="https://community.qlik.com/message/1415908">Re: how to write script for Aggregate</A></P></BODY></HTML> Wed, 24 Jan 2018 18:35:01 GMT sunny_talwar 2018-01-24T18:35:01Z how to write script for Aggregate https://community.qlik.com/t5/QlikView/how-to-write-script-for-Aggregate/m-p/1453273#M434719 <HTML><HEAD></HEAD><BODY><P>Hi All:</P><P></P><P>i know Aggr isn't available for Script, is there any way we can develop for Script loading? thanks heaps</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>country</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>region</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>sales</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>sales by Region</STRONG></TH></TR><TR><TD style="padding: 2px;">jap</TD><TD style="padding: 2px;"><P>Asia</P></TD><TD style="padding: 2px;">80</TD><TD style="padding: 2px;">210</TD></TR><TR><TD style="padding: 2px;">koran</TD><TD style="padding: 2px;">Asia</TD><TD style="padding: 2px;">70</TD><TD style="padding: 2px;">210</TD></TR><TR><TD style="padding: 2px;">uk</TD><TD style="padding: 2px;">Euro</TD><TD style="padding: 2px;">50</TD><TD style="padding: 2px;">70</TD></TR><TR><TD style="padding: 2px;">china</TD><TD style="padding: 2px;">Asia</TD><TD style="padding: 2px;">60</TD><TD style="padding: 2px;">210</TD></TR><TR><TD style="padding: 2px;">france</TD><TD style="padding: 2px;">Euro</TD><TD style="padding: 2px;">20</TD><TD style="padding: 2px;">70</TD></TR></TBODY></TABLE><P></P><P>what's the script i can calculate Sales by Region.</P><P></P><P>thanks heaps</P></BODY></HTML> Thu, 11 Jan 2018 05:55:08 GMT https://community.qlik.com/t5/QlikView/how-to-write-script-for-Aggregate/m-p/1453273#M434719 yink-hpv 2018-01-11T05:55:08Z Re: how to write script for Aggregate https://community.qlik.com/t5/QlikView/how-to-write-script-for-Aggregate/m-p/1453274#M434720 <HTML><HEAD></HEAD><BODY><P>Like this</P><P></P><P><STRONG>Table:</STRONG></P><P><STRONG>LOAD country,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; region,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp; sales</STRONG></P><P><STRONG>FROM ...;</STRONG></P><P></P><P><STRONG>Left Join (Table)</STRONG></P><P><STRONG>LOAD region,</STRONG></P><P><STRONG>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sum(sales) as [sales by Region]</STRONG></P><P><STRONG>Resident Table</STRONG></P><P><STRONG>Group By region;</STRONG></P></BODY></HTML> Thu, 11 Jan 2018 15:15:32 GMT https://community.qlik.com/t5/QlikView/how-to-write-script-for-Aggregate/m-p/1453274#M434720 sunny_talwar 2018-01-11T15:15:32Z Re: how to write script for Aggregate https://community.qlik.com/t5/QlikView/how-to-write-script-for-Aggregate/m-p/1453275#M434721 <HTML><HEAD></HEAD><BODY><P>thanks Heaps Sunny</P></BODY></HTML> Thu, 11 Jan 2018 21:37:35 GMT https://community.qlik.com/t5/QlikView/how-to-write-script-for-Aggregate/m-p/1453275#M434721 yink-hpv 2018-01-11T21:37:35Z Re: how to write script for Aggregate https://community.qlik.com/t5/QlikView/how-to-write-script-for-Aggregate/m-p/1453276#M434722 <HTML><HEAD></HEAD><BODY><P>No problem at all <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>Please close the thread down by marking correct response.</P><P></P><P><A href="https://community.qlik.com/docs/DOC-14806">Qlik Community Tip: Marking Replies as Correct or Helpful</A></P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Fri, 12 Jan 2018 00:52:05 GMT https://community.qlik.com/t5/QlikView/how-to-write-script-for-Aggregate/m-p/1453276#M434722 sunny_talwar 2018-01-12T00:52:05Z Re: how to write script for Aggregate https://community.qlik.com/t5/QlikView/how-to-write-script-for-Aggregate/m-p/1453277#M434723 <HTML><HEAD></HEAD><BODY><P>Hi sunny: i don't have correct answer to choose, so i marked as helpful.</P></BODY></HTML> Wed, 24 Jan 2018 01:48:44 GMT https://community.qlik.com/t5/QlikView/how-to-write-script-for-Aggregate/m-p/1453277#M434723 yink-hpv 2018-01-24T01:48:44Z Re: how to write script for Aggregate https://community.qlik.com/t5/QlikView/how-to-write-script-for-Aggregate/m-p/1453278#M434724 <HTML><HEAD></HEAD><BODY><P>Are you opening this thread or are you viewing it from the inbox? Inbox view doesn't show the option to select correct answer. Try clicking here to see if you see the option to mark correct answer</P><P><A href="https://community.qlik.com/message/1415908">Re: how to write script for Aggregate</A></P></BODY></HTML> Wed, 24 Jan 2018 18:35:01 GMT https://community.qlik.com/t5/QlikView/how-to-write-script-for-Aggregate/m-p/1453278#M434724 sunny_talwar 2018-01-24T18:35:01Z