topic Re: Text on chart based on Expression in QlikView

Text on chart based on Expression

Anonymous — Wed, 15 Jul 2015 09:55:12 GMT

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 — Wed, 15 Jul 2015 10:16:07 GMT

I think this could be a solution:

prashantbaste — Wed, 15 Jul 2015 10:23:03 GMT

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 — Wed, 15 Jul 2015 10:46:42 GMT

Thaks for your Time.

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

prashantbaste — Wed, 15 Jul 2015 12:59:47 GMT

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 — Wed, 15 Jul 2015 13:03:13 GMT

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