Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
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