Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

Hi All

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

Paul

1 Solution

Accepted Solutions
Not applicable
Author

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!

View solution in original post

12 Replies
Not applicable
Author

Enclosed my QV doc.

Sokkorn
Master
Master

Hi Paul,

Your title should be use this expression

=  ''    &GetFieldSelections(GROUP_CLASS)& '' &     /* .

Regards,

Sokkorn

Sokkorn
Master
Master

Or this one

='[GROUP_CLASS] ' &GetFieldSelections(GROUP_CLASS)

sujeetsingh
Master III
Master III

Just call expression as :

getFieldtselection(Group_Class) in title

Not applicable
Author

Hi All

Thank you both of you reply my question.

But i need it a bit more flexible. See the enclosed QV Doc

MK_QSL
MVP
MVP

What do you mean by More Flexible ?

Please specify..

You can use below..

='[GROUP_CLASS] ' &CONCAT(GetFieldSelections(GROUP_CLASS),', ')

Not applicable
Author

Can you tell us what exactly you need in the title?

You can create an inline table to link:

  'BECKHOFF','BEC',
  'HAKKO','HAK',
  'GE FANUC','GEF',..

  ...

  ...

and then use the inline field to get something like:

=     '[GROUP_CLASS] ' & GetFieldSelections(GROUP_CLASS) & 'Brand '  & GetFieldSelections(InlineField)

        to get

          GROUP_CLASS G1 BRAND BEC

Regards,
Robinson

Not applicable
Author

Hi Robinson

Many thank for your sample code .

Sorry i never write clearly , i try to be more detail now .

At one time user may select either one of the below  :-

BRA_C or GP_C

When user select BRA_C with the Below  :-

BRA_C   HAK   i need the title display BRA_C   HAK

BRA_C   GEF   i need the title display BRA_C   GEF

When user select GP_C with the Below  :-

GP_C   G1   i need the title display GP_C G1

GP_C   G2   i need the title display GP_C G2

Hope it is clear now.

Paul

Paul

MK_QSL
MVP
MVP

=IF(GetFieldSelections([Pls select 101st Dim])= 'BRA_C',

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

  IF(BRAND_='BECKHOFF','BEC',

  IF([BRAND_]= 'HAKKO','HAK',

  IF([BRAND_]= 'GE FANUC','GEF',

  IF([BRAND_]= 'MITSUBISHI','MIT',

  IF([BRAND_]= 'OTHER','OTH',

  If([BRAND_]='REDLION','RED',

  If([BRAND_]='SCHAFFNER','SCH',

  If([BRAND_]='HENGSTLER','HEN',

  If([BRAND_]='HMS','HMS'))))))))),

IF(GetFieldSelections([Pls select 101st Dim]) = 'GP_C',

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

  IF(GROUP_CLASS='G1',GROUP_CLASS,

  IF([GROUP_CLASS]= 'G2',[GROUP_CLASS],

  IF([GROUP_CLASS]= 'G3',[GROUP_CLASS],

  IF([GROUP_CLASS]= 'G4',[GROUP_CLASS],

  IF([GROUP_CLASS]= 'G7',[GROUP_CLASS],

  IF([GROUP_CLASS]= 'G6',[GROUP_CLASS],

  IF([GROUP_CLASS]= 'G8',[GROUP_CLASS],

  IF([GROUP_CLASS]= 'G9',[GROUP_CLASS],

  IF([GROUP_CLASS]= 'G5',[GROUP_CLASS],

  IF([GROUP_CLASS]= 'G10',[GROUP_CLASS],

  IF([GROUP_CLASS]= 'G11',[GROUP_CLASS],

  IF([GROUP_CLASS]= 'G12',[GROUP_CLASS]))))))))))))))