Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Load dynamically Month column

May be use a crosstable load here:

The Crosstable Load

2 Replies

Re: Load dynamically Month column

May be use a crosstable load here:

The Crosstable Load

Re: Load dynamically Month column

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

thanks

regards

Marco

Community Browser