When i tick on G1 from G1 to G10 , How to make G1 display on title ?

[#1]

Hi All

My question as per above mentioned. See my QV doc for more information.

Paul

[#2 · Accepted solution]

Hi Paul,

First thing, you can have all the if conditions you are using for Brand_  and Group_Class list boxes in the backend and create a new field say BRAND and GROUP_CLASS, now you can have the following expression to show the desired title:

=If(GetFieldSelections([Pls select 101st Dim]) = 'BRA_C', GetFieldSelections([Pls select 101st Dim]) & ' ' & GetFieldSelections([BRAND]),
If(GetFieldSelections([Pls select 101st Dim]) = 'GP_C', GetFieldSelections([Pls select 101st Dim]) & ' ' & GetFieldSelections(GROUP_CLASS)
))

Where BRAND and GROUP_CLASS are the newly created fields in the backend based on the if conditions you need.

And you can add further if you need more if conditions.

Hope this helps!

[#3]

Hi Paul,

First I would suggest you to create an inline table as follows:

LOAD * INLINE [

BRAND_,          BRAND_Shortname

BECKHOFF,      BEC

HAKKO,            HAK

GE FANUC,       GEF

MITSUBISHI,   MIT

OTHER,            OTH

REDLION,        RED

SCHAFFNER,   SCH

HENGSTLER,   HEN

HMS,               HMS

];

This is to avoid assigning the shortnames for the BRAND_ in the list box
So now you have 3 fields that you need to display in the chart title, based on which ones are selected

1 Pls select 101st Dim

2 GROUP_CLASS

3 BRAND_Shortname (from above inline table)

Now in the chart title you can use something like this:

=GetFieldSelections([Pls select 101st Dim]) & ' '&

If(GetFieldSelections(GROUP_CLASS)>1, GetFieldSelections(GROUP_CLASS), if(GetFieldSelections(BRAND_Shortname)>1, GetFieldSelections(BRAND_Shortname)))

Best Regards,

Robinson

[#4]

Hey Paul,

Or maybe you can use the below:

=GetFieldSelections([Pls select 101st Dim]) & '  '&

If(GetPossibleCount(GROUP_CLASS)>1, GetFieldSelections(GROUP_CLASS), if(GetPossibleCount(BRAND_Shortname)>1, GetFieldSelections(BRAND_Shortname)))

This code will check if you have made exactly 1 selection in each of the respective fields.

Regards,

Robinson