topic Label in Pivot table in QlikView

Label in Pivot table

Mon, 08 Feb 2010 17:58:00 GMT

Hi All,

I need a help from you. Please look at the attached image. I need to show the "Month to date variance to budget in 3 lines" What is the ASCII characters for New line.

Thanks,

Raghu.

Label in Pivot table

Mon, 08 Feb 2010 18:04:30 GMT

Hi Raghu

Try

='Month' & chr(13) & 'To' & chr(13) & 'Date'

Label in Pivot table

Mon, 08 Feb 2010 18:16:44 GMT

Thanks Nigel

Label in Pivot table

Thu, 11 Feb 2010 09:30:19 GMT

Nigel,

The words are coming in the next line when we use chr(13) but in the pivot table whole thing i cant see. when we move the mouse then only it is visible. How can i make it fully visible.

-Raghu.

Label in Pivot table

Thu, 11 Feb 2010 09:30:49 GMT

Nigel,

The words are coming in the next line when we use chr(13) but in the pivot table whole thing i cant see. when we move the mouse then only it is visible. How can i make it fully visible.

Without moving the mouse i can see the complete thing. How can i do that?

-Raghu.

Label in Pivot table

Thu, 11 Feb 2010 09:44:45 GMT

Hi Raghu

You need to set the height of the heading bar to 3 lines, do this in the Presentation tab of the properties of the pivot.

Cheers,

Label in Pivot table

Thu, 11 Feb 2010 11:05:49 GMT

Thanks Nigel,

Its working

-Raghu.