Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

how i can dynamic column in script level

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.

1 Solution

Accepted Solutions
MVP
MVP

Re: how i can dynamic column in script level

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

7 Replies
MVP
MVP

Re: how i can dynamic column in script level

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

Re: how i can dynamic column in script level

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

Not applicable

Re: how i can dynamic column in script level

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

MVP
MVP

Re: how i can dynamic column in script level

crosstable(year,status,2)

load

*

from table;

Not applicable

Re: how i can dynamic column in script level

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

MVP
MVP

Re: how i can dynamic column in script level

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

Not applicable

Re: how i can dynamic column in script level

thanks that was simple...

Community Browser