topic Re: Text object in verticle value in QlikView

Text object in verticle value

Anonymous — Tue, 20 Jun 2017 06:42:01 GMT

Hi All,

Kindly please share the value should in vertically.

Ex:

Year

2014,2015,2016

O/P

2014

2015

Thanks

Anil_Babu_Samineni — Tue, 20 Jun 2017 06:43:49 GMT

Use

Concat(Year,Chr(10))

Anonymous — Tue, 20 Jun 2017 07:18:11 GMT

Great help,Thanks you

Anil_Babu_Samineni — Tue, 20 Jun 2017 07:19:24 GMT

Please close this thread by flag Correct answer. And i recommend you to search on community rather creating the Thread

ahaahaaha — Tue, 20 Jun 2017 14:39:27 GMT

Hi,

If it's in a script, then as an variant

Table1:

LOAD*Inline

[Year

'2014, 2015, 2016'

];

Left Join

LOAD*,

SubField(Year, ',', IterNo()) as NewYear

Resident Table1

While IterNo() <= SubStringCount(Year,',')+1;

Drop Field Year;