Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load dynamically Month column

Hi,

I need help to implement this feature in my script:

I have an excel file with the last 6 month

Jan 16 Feb 16Mar 16Apr 16May 16Jun 16
valuevaluevaluevaluevaluevalue
valuevaluevaluevaluevaluevalue

how con I upload this automatically in my sheet without modify the structure of the table?

My idea was to have a pivot table with all month for 5 years and display only them specified into the excel file, but if I try this idea i receive an upload error.

Anyone has some idea on how to resolve my problem?

Other ideas are accepted of course.

Thanks

1 Solution

Accepted Solutions
sunny_talwar

May be use a crosstable load here:

The Crosstable Load

View solution in original post

2 Replies
sunny_talwar

May be use a crosstable load here:

The Crosstable Load

MarcoWedel

Please post a small sample of your excel file, the script and the error message.

thanks

regards

Marco