How to upload different data for same contend

[#1]

Hi All,

i am a new bee in QV, right now i m facing some problem while  uploading the data, in an excel i have two type of data for many countries and products for past 36 months one is the actual value and other is the cumulated slaes value, if i upload the problem is for same 36 months i have the two different values, any help is appreciated

[vijay_iitkgp]

I think You dont need to upload cumulative file. It can be easily done in Qlikview. Still if you want to use this cumulative sales then rename this field to differeent name (say CumulativeSales)

[#3]

Hi Vijay thanks for your reply,

i need this cummulatve values becoz these values are not calculated based on the actual values, Can you be brief abt different field name, can you tell how,

[vijay_iitkgp]

You can Use:

Load

Slaes ,

Field1,Field2

From Table1;

Concatenate

Load

Sales As CumulativeSales,

Field1,

Field2

From Table2

[#5 · Accepted solution]

Hi Vijay Thanks for the tip, actually there are 36 months and wht i have done is i have taken the cumulative values in different sheet and then i have uploaded it separetely and i have taken sheet name as a different filed, any way thanks alot for you tip