Text on chart based on Expression

[Anonymous]

hi Gurus

i have Year as Dimension

number as Expression

India  Usa China

4        8     16

i want to display Text on Y axis ,

if Number =4 -> D1

if Number=8-> D2

if Number =16->D3  as shown in sample application

How to write an expression in text on chart

[alexandros17 · Accepted solution]

I think this could be a solution:

[prashantbaste]

Hi

Do you want a dynamic positioning of Text in chart or what?

Or if you have a fix position & want to check value 4 with Country & its number - you can write expression as -

Use Script as -

Load Country,

         Number

From table.qvd(qvd);

Load Inline [

Country, DNumber

India, D1

USA, D2

China, D3

];

& In charts -> Text In Chart write expression as - =Only({<Number={'4'}>} DNumber)

Hope this will be helpful for you.

--

Regards,

Prashant P Baste

[Anonymous]

Hi

Alessandro,

Thaks for your Time.

the lables coming to inside plotting  area .is there any possibility to plot out side y Axis

[prashantbaste]

You need to manually place them. There is no provision for dynamic placement of text in chart.

Once you entered text...come out of properties.

Simply click on chart & by pressing [Ctrl+Shift] you can place those texts anywhere at suitable place in chart.

[alexandros17]

I think no with an automatic setting ... otherwise you have to place on your own ....