topic Carriage return in expression in QlikView

Carriage return in expression

Wed, 30 May 2012 10:33:48 GMT

Hi,

I would like to insert a carriage return in an expression. A example would be

=concat({[alternate state1]'field',chr(10)&chr(13)).

I am displaying all the selections in field as the label of an expression. But this doesn't seem to work. Could anyone help me?

Regards,

Xue Bin

Carriage return in expression

m_woolf — Wed, 30 May 2012 11:55:37 GMT

get rid of chr(13)

Carriage return in expression

Thu, 31 May 2012 02:01:02 GMT

Hi,

It doesn't work. I made some typo in my previous post though. The expression should be

=concat({[alternate state1]}field,chr(10)&chr(13)).

removing chr(13) doesn't work. And a red line appears under chr(10) indicating some syntax error?

Regards,

Xue Bin

Re: Carriage return in expression

jagan — Thu, 31 May 2012 07:12:16 GMT

Hi,

Check attached file

I used

=Concat(F1, chr(10))

Where F1 is a field, it works.

Regards,

Jagan.

Re: Carriage return in expression

Thu, 31 May 2012 07:21:30 GMT

Hi Jagan,

I don't own a license but i tried to move the expression to the title of the chart and it works. It seems that the label of an expression only support one line. When I move it back to the label of my expression, it returns only one value. The rest of the values seems to be truncated.

Regards,

Xue Bin

Re: Carriage return in expression

jagan — Thu, 31 May 2012 07:35:15 GMT

Hi,

Assign this expression (=Concat(F1, chr(10))) to a variable and try using this variable as a label for expression.

This works for me. Check attached screenshot.

Hope this helps you.

Regards,

Jagan.

Re: Carriage return in expression

Thu, 31 May 2012 08:16:13 GMT

Hi,

My objective is to make this 'F1' in your screenshot to

not the title of the chart. I tried to assign it to a variable during loading. But the variable turns out to be empty. I am very inexperienced with variable. Is there a way to declare a variable in visualization?

Regards,

Xue Bin

Carriage return in expression

jagan — Thu, 31 May 2012 09:44:20 GMT

Hi,

That is not the title of the chart, it is expression name. You can create a variable using menu

Settings -> Variables Overview -> Add -> give variable name (Ex: vTest) -> Give variable definition (=Concat(F1, chr(10))).

Now press Ok

Now use variable (vTest) as =vTest in Expression label

Hope this helps you.

Regards,

Jagan.

Carriage return in expression

Thu, 31 May 2012 09:58:29 GMT

Hi Jagan,

Really appreciate your patience. It still works the same, showing only the first value. I attach some screenshots here. I think it must be some issue with the expression label. I am doing comparative analysis and have two expessions on Y-axis. The labels appear on the right of the graph as shown in the screen shot

Carriage return in expression

jagan — Thu, 31 May 2012 10:13:52 GMT

Hi,

Can you attach sample file you are working?

Regards,

Jagan.

Re: Carriage return in expression

Thu, 31 May 2012 11:36:13 GMT

Hi,

Attached is my qvw file. Thank you so much:)

Regards,

Xue Bin

Re: Carriage return in expression

jagan — Thu, 31 May 2012 12:05:39 GMT

Hi,

I found the issue, it is the problem in Legend. To fix this

Chart Properties -> Presentation Tab -> Legend Section -> Click Setting button -> Select "Wrap Text" ->

Give Cell Height value to 10 or 20 depending on the values to get.

Check attached screen shot. Hope this helps you.

Regards,

Jagan.

Re: Carriage return in expression

Thu, 31 May 2012 12:17:51 GMT

Hi Jagan,

Yes that solves the problem. You are great:)

Regards,

Xue Bin