topic Load 'n' columns in QLikview in QlikView

Load 'n' columns in QLikview

Wed, 27 Jul 2016 05:36:39 GMT

Hi All,

I have an excel which have sales data week wise.

Each week a new week column will be added and the number of columns will not be constant.

I am using a cross table in order to get the sales in single column.

Now the problem is the new columns,so each week i have to add the new week field in the script to get the latest data Manually.

Is there any way to automate it so that the the script can load the newly added field by itself.

Thanks in advance..

Regards,

Reena

vikasmahajan — Wed, 27 Jul 2016 05:44:25 GMT

Simply Use Load * from Xls it will automatically adds newly added columns.

Vikas

Wed, 27 Jul 2016 05:48:47 GMT

Yes,

i tried.but the new columns were not loaded when using a cross table.

anagharao — Wed, 27 Jul 2016 06:35:05 GMT

Hi,

You could load the table without pivoting it and create columns on the number of values in Month and Week column.

Hope thats useful.