Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
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
tresesco
MVP
MVP

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

View solution in original post

7 Replies
tresesco
MVP
MVP

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

CELAMBARASAN
Partner - Champion
Partner - Champion

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

Not applicable
Author

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
MVP
MVP

crosstable(year,status,2)

load

*

from table;

Not applicable
Author

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
MVP
MVP

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

Not applicable
Author

thanks that was simple...