how i can dynamic column in script level

[#1]

i want to add dynamic column at script level..

i have years in my data

2010-2014

and what i need is --

I need dynamic column with year changing from 2014 to 2015 and likewise for other years.

[tresesco]

Could you post a sample explaining a bit more about your desired output?

[CELAMBARASAN]

You could post the script that you are using now and explain. It will be helpful to understand your problem easily

[#4]

i have crosstable ,in which i have data corresponding to years (2011 to 2014)
crosstable(year,status,2)

load

sr_ no,

indicator,

2011,

2012,

2013,

2014

from table;

now i want qlikview to add a column dynamicaly wenever there is value for new column ie for the year 2015

[tresesco]

crosstable(year,status,2)

load

*

from table;

[#6]

hi

i dont want it to be hard core.i want qlikview to add a column for new year dynamicaly as and when a new year gets added in excel.i.e 2015

thanks

[tresesco · Accepted solution]

The code I mentioned above would do that, try. Instead of mentioning the names of fields, load using '*' .

[#8]

thanks that was simple...