Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Like this
Table:
LOAD country,
region,
sales
FROM ...;
Left Join (Table)
LOAD region,
Sum(sales) as [sales by Region]
Resident Table
Group By region;
thanks Heaps Sunny
No problem at all
Please close the thread down by marking correct response.
Qlik Community Tip: Marking Replies as Correct or Helpful
Best,
Sunny
Hi sunny: i don't have correct answer to choose, so i marked as helpful.
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