how to write script for Aggregate

[yink-hpv]

Hi All:

i know Aggr isn't available for Script, is there any way we can develop for Script loading? thanks heaps

country	region	sales	sales by Region
jap	Asia	80	210
koran	Asia	70	210
uk	Euro	50	70
china	Asia	60	210
france	Euro	20	70

what's the script i can calculate Sales by Region.

thanks heaps

[sunny_talwar]

Like this

Table:

LOAD country,

     region,

     sales

FROM ...;

Left Join (Table)

LOAD region,

      Sum(sales) as [sales by Region]

Resident Table

Group By region;

[yink-hpv]

thanks Heaps Sunny

[sunny_talwar]

No problem at all

Please close the thread down by marking correct response.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny

[yink-hpv]

Hi sunny: i don't have correct answer to choose, so i marked as helpful.

[sunny_talwar]

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

Re: how to write script for Aggregate