Use multiple fields as one.

[#1]

I have multiple fields that includes sales and period.

example:

t_tovr_1 = sales in month '1'

t_tovr_2 = sales in month '2' etc...

Can anyone tell me how to load these fields in one field of 'sales' and in one field 'month'

[#2]

Hi,

Can you rephrase your scenario and explain us briefly the same so tat it would be easy for us to suggest the solution.

- Sridhar

[#3]

Hi!

I think you are looking for the crosstable load:

crosstable(Month,Sales,1)LOAD * INLINE [ SalesPerson,t_tovr_1, t_tovr_2, t_tovr_3 A,1,2,3 B,2,3,4 C,5,6,4];

[#4]

Hi,

We have 12 seperate fields 't_tovr_1, t_tovr_2..........t_tovr_12'

Field t_tovr_1 = 'sales januari'

Field t_tovr_2 = 'sales februari' etc.......

I want to load the sales and the months into qlikview. What is the best workaround for this problem.

Thanks,

Roy

[#5 · Accepted solution]

Hi!

Please see the attached example!