topic Group by function in QlikView

Group by function

Wed, 11 Dec 2013 06:30:23 GMT

Have a requirement to sum up total sale amount for each region from two different text files. In one file i have geography information and in another file have sales information at sub-region wise. Have to join with first file to get region level total sales information.

example: select total_sales, region from sales, geography where sales.sub_region=geography.sub_region group by geography.region.

Please provide your ideas.

Re: Group by function

Wed, 11 Dec 2013 06:39:04 GMT

try according to this example

firstly join two table in one table.

NewTable:

table1

join

table2

**************************

then

output:

load

field1,

sum(field2)

resident NewTable

group by field1;