topic exp help in QlikView

exp help

abhaysingh — Fri, 16 Jan 2015 08:45:52 GMT

HI all

i have one table field which contain year 2014 and some integer values in it .

i.e.

Table

2014

1.2

2.3

2.4

3 and so on

i want to pick 2014 from it as a year and also want to add 2015 in it.

how can i do it.

output i need is

i.e.

Table

2014

2015

1.2

2.3

2.4

3 and so on

kindly help asap

alexandros17 — Fri, 16 Jan 2015 08:49:24 GMT

If you need to add 2015 as valur for your field then:

Load * from table

concatenate

load * inline [

myfield

2015

];

let me know

anbu1984 — Fri, 16 Jan 2015 09:37:23 GMT

Tbl:

Load * Inline [

Txt

2014

1.2

2.3

2.4

3 ];

Load Txt+1 As Txt Resident Tbl Where IsNum(Txt) And Len(Txt) = 4;