topic How to upload different data for same contend in QlikView

How to upload different data for same contend

Thu, 23 Feb 2012 07:39:54 GMT

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

How to upload different data for same contend

vijay_iitkgp — Thu, 23 Feb 2012 07:44:04 GMT

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)

How to upload different data for same contend

Thu, 23 Feb 2012 08:04:20 GMT

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,

How to upload different data for same contend

vijay_iitkgp — Thu, 23 Feb 2012 08:08:39 GMT

You can Use:

Load

Slaes ,

Field1,Field2

From Table1;

Concatenate

Load

Sales As CumulativeSales,

Field1,

Field2

From Table2

How to upload different data for same contend

Thu, 23 Feb 2012 09:19:48 GMT

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