Skip to main content
Announcements
Marching toward a simplified navigation! READ ON
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use multiple fields as one.

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'





1 Solution

Accepted Solutions
Not applicable
Author

Hi!

Please see the attached example!

View solution in original post

4 Replies
Not applicable
Author

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

Not applicable
Author

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];
Not applicable
Author

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

Not applicable
Author

Hi!

Please see the attached example!