topic Re: adding same company name into one with corresponding value in QlikView

adding same company name into one with corresponding value

Anonymous — Mon, 12 Mar 2012 06:55:13 GMT

hi folks,

i have data like this

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

Thanks in Advance

CELAMBARASAN — Mon, 12 Mar 2012 07:06:16 GMT

Hi,

Try like this

Load

Upper(unit) as Unit,

Sum(value) as Value

Resident

TableName

Group by Upper(unit);

Hope it helps

Celambarasan

Anonymous — Mon, 12 Mar 2012 07:36:27 GMT

hi plz solve with little example,

iam unable to achieve the desire result.

resident table load showing error

THANKS,

CELAMBARASAN — Mon, 12 Mar 2012 07:39:13 GMT

Hi,

Original:

Load

Upper(unit) as Unit,

Sum(value) as Value

From

Datasource

Group by Upper(unit);