topic Use multiple fields as one. in QlikView

Use multiple fields as one.

Wed, 10 Jun 2009 18:34:09 GMT

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'

Wed, 10 Jun 2009 18:42:59 GMT

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

Wed, 10 Jun 2009 18:44:37 GMT

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];

Wed, 10 Jun 2009 19:05:25 GMT

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

Wed, 10 Jun 2009 19:21:35 GMT

Hi!

Please see the attached example!