i want to add dynamic column at script level..
i have years in my data
and what i need is --
I need dynamic column with year changing from 2014 to 2015 and likewise for other years.
Could you post a sample explaining a bit more about your desired output?
i have crosstable ,in which i have data corresponding to years (2011 to 2014)crosstable(year,status,2)
now i want qlikview to add a column dynamicaly wenever there is value for new column ie for the year 2015
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
The code I mentioned above would do that, try. Instead of mentioning the names of fields, load using '*' .
thanks that was simple...
You could post the script that you are using now and explain. It will be helpful to understand your problem easily
Retrieving data ...