topic Load excel column into text object in QlikView

Load excel column into text object

Anonymous — Thu, 11 Jun 2015 14:34:10 GMT

Hi, in my script I have a loaded a spreadsheet with 5 columns. I want to be able to create a text object that only pulls one of those columns. I've tried an if statement, only statement and nothing is working. Help?

Re: Load excel column into text object

giakoum — Thu, 11 Jun 2015 14:35:08 GMT

=concat(yourColumn, ',')

Re: Load excel column into text object

maxgro — Thu, 11 Jun 2015 14:37:10 GMT

maybe

=concat(oneofthecolumn & chr(10))

Re: Load excel column into text object

Anonymous — Thu, 11 Jun 2015 14:40:54 GMT

Thank you. And if I wanted to show the values of 2 columns???

Column 1 Column 2

Value 1 Value 2

Re: Load excel column into text object

Peter_Cammaert — Thu, 11 Jun 2015 14:42:27 GMT

Create two text objects and align them in such a way that they appear as one.

Peter

Re: Load excel column into text object

awhitfield — Thu, 11 Jun 2015 14:42:43 GMT

Using something other tan a text object would be best

Andy

Re: Load excel column into text object

Peter_Cammaert — Thu, 11 Jun 2015 14:44:50 GMT

Andrew is right.

For example, you can give a Table Box the appearance of a text object by giving all cell borders the same color as the background. Nobody will notice that your are playing tricks

Peter

Re: Load excel column into text object

Anonymous — Thu, 11 Jun 2015 14:47:19 GMT

Thank you all.