Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
The code I mentioned above would do that, try. Instead of mentioning the names of fields, load using '*' .
Could you post a sample explaining a bit more about your desired output?
You could post the script that you are using now and explain. It will be helpful to understand your problem easily
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
crosstable(year,status,2)
load
*
from table;
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
The code I mentioned above would do that, try. Instead of mentioning the names of fields, load using '*' .
thanks that was simple...