topic Re: how i can dynamic column in script level in QlikView

how i can dynamic column in script level

Fri, 06 Jun 2014 05:26:41 GMT

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.

tresB — Fri, 06 Jun 2014 05:29:05 GMT

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

CELAMBARASAN — Fri, 06 Jun 2014 05:36:04 GMT

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

Fri, 06 Jun 2014 05:39:03 GMT

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

tresB — Fri, 06 Jun 2014 05:43:59 GMT

crosstable(year,status,2)

load

from table;

Fri, 06 Jun 2014 05:51:06 GMT

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

tresB — Fri, 06 Jun 2014 05:56:04 GMT

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

Fri, 06 Jun 2014 06:14:18 GMT

thanks that was simple...