dynamic label?

[#1]

HI All,

I have list box  name flag having, Prim & Sec..

I select Prim in List box Straight table Label should come as Prim.

I select Sec in List box Straight table Label should come as Sec

Regards,

Helen

[amit_saini]

Hi,

See the attachment.

Thanks,

AS

[#3]

Try something like this :

if (getfieldselections(flag)='Prim','Prim','Sec') in Title of the chart.

Regards,

Balakrishnan.R

[nagarjuna_kotha]

Hi

Like this :

We have two ways achieving this :

1. Normal Field in Label Like "=Field"

2.Using GetFieldSelections

See attached.

Hope this may help.

Regards,

Nagarjun !

[avinashelite]

Add this expression in the chart label

Getfieldselections(flag)

[#6]

With in the Flag what ever  i will match, i need to show that Name..

Example: Flag =Prim, then i need show label name as Sales

               Flag =Sec, then i need show label name as PriSales

Regards,

Helen

[adamdavi3s]

use = pick(match(flag,Prim,Sec),'Sales','PriSales')

Sorry I might have the syntax a little off but it should be close

[avinashelite · Accepted solution]

Try like this

if(trim(Getfieldselections(flag))='Prim','Sales',if(trim(Getfieldselections(flag))='Sec','PriSales','Default_Msg'))

[adamdavi3s]

I'm interested to discuss but I would always use pick(match( over IF statements where possible, IF statements are really inefficient....

this is the correct formula: =pick(match(flag,'Prim','Sec'),'Sales','PriSales')

[avinashelite]

with limited values both would perform the same(i.e with the current scenario we have only 2 values), with the large data comparison I would prefer using the Pick and match combination ..hope this make sense