adding same company name into one with corresponding value

[Anonymous]

hi folks,

i have data like this

Header 1	Header 2
unit	value
India	100
Usa	200
INDIA	300
USA	200
CANADA	100
canada	500

how can i add same country into one , this data(unit names ) was  already loaded into qlikview .

Thanks in Advance

[CELAMBARASAN]

Hi,

     Try like this

Load

     Upper(unit) as Unit,

     Sum(value) as Value

Resident

     TableName

Group by Upper(unit);

Hope it helps

Celambarasan

[Anonymous]

hi plz solve with little example,

iam unable to achieve the desire result.

resident table load showing error

THANKS,

[CELAMBARASAN · Accepted solution]

Hi,

Original:

Load

     Upper(unit) as Unit,

     Sum(value) as Value

From

     Datasource

Group by Upper(unit);