topic About the expression in QlikView

About the expression

Wed, 27 Oct 2010 14:24:28 GMT

Hello;

I have this sentence in my table expression:

concat({<Type={'Store'}>}Model,' ; ')

I want to insert all new Models in new line (Instead to separate the models with ";" sign)

How can I do this?

Elad

Wed, 27 Oct 2010 14:33:34 GMT

seems right. What kind of error you get?

concat(Distinct Name,' ; ') is the code. How he works without set analys?

Wed, 27 Oct 2010 16:15:50 GMT

Instead of them all being on one line, you want them all to be on separate lines?

If so, then you need to add Model as a dimension.

johnw — Wed, 27 Oct 2010 20:48:38 GMT

Put the new line between the quotes. You may also need the "distinct" keyword depending on your data model.

concat({<Type={'Store'}>} distinct Model,'
')

boorgura — Wed, 27 Oct 2010 22:03:50 GMT

You can use chr(10) in place of ' ; '.

chr(10) is equivalent to next line.

Wed, 27 Oct 2010 23:32:54 GMT

I use chr(13) for new lines.

boorgura — Wed, 27 Oct 2010 23:34:41 GMT

chr(10) maps to new line

chr(13) maps to carriage return... finally doing the same thing