add same field names data while loading

[Anonymous]

hi folks,

how to add unit1+unit1=unit1 revenue

                 unit2+unit2=unit2 revenue in advance.venue

                 unit3+unit3=unit3 revenue

while loading flat file data into qlikview.

plz find the attached excel file.

thanks in advance

[CELAMBARASAN]

Hi,

     Try with this

LOAD bu,

     Sum(revenue) as revenue

FROM

DataSource\commu.bu.xlsx

(ooxml, embedded labels, table is Sheet1) Group by bu;

Hope it helps

Celambarasan

[Anonymous]

hi thanks for quick responce.

in real data

i need to add ap+mh=unit1

del+no=unit2

like this

[CELAMBARASAN]

Hi,

     Could you tell me brief about the full structure of the table?its easy to me understand and solve.

Celambarasan

[Anonymous]

hi,

plz find the attached qvw.

Thanks In Advance

[CELAMBARASAN]

Hi,

     I'm using personal edition i cann't open your file.Can you tell me about a structure itself?

Celambarasan

[Anonymous]

hi

plz find excel sheet

[jagan]

Hi,

Please check the Excel file and let me know, this is what you require.

Regards,

Jagan.

[jagan]

Hi,

Please check the Excel file and let me know, this is what you require.

Regards,

Jagan.

[Anonymous]

hi jagan,

plz find the attached Excel file

Thanks For ur quick responce