Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2014-02-19 11:27 PM

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,207 Views
1 Solution

Accepted Solutions
Not applicable
‎2014-02-20 02:58 AM
Author

In response to

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

851 Views
0 Likes
12 Replies
Not applicable
‎2014-02-19 11:29 PM
Author

Enclosed my QV doc.

000_QVD_v867 ask how to display G1.qvw
660 Views
0 Likes
Sokkorn
Master
Master
‎2014-02-19 11:38 PM

In response to

Hi Paul,

Your title should be use this expression

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

Regards,

Sokkorn

660 Views
0 Likes
Sokkorn
Master
Master
‎2014-02-19 11:39 PM

In response to Sokkorn

Or this one

='[GROUP_CLASS] ' &GetFieldSelections(GROUP_CLASS)

660 Views
0 Likes
sujeetsingh
Master III
Master III
‎2014-02-19 11:40 PM

Just call expression as :

getFieldtselection(Group_Class) in title

660 Views
0 Likes
Not applicable
‎2014-02-19 11:55 PM
Author

In response to sujeetsingh

Hi All

Thank you both of you reply my question.

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

000_QVD_v867 ask how to display G10.qvw
660 Views
0 Likes
MK_QSL
MVP
MVP
‎2014-02-20 02:18 AM

What do you mean by More Flexible ?

Please specify..

You can use below..

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

660 Views
0 Likes
Not applicable
‎2014-02-20 02:24 AM
Author

In response to

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

660 Views
0 Likes
Not applicable
‎2014-02-20 02:39 AM
Author

In response to

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

660 Views
0 Likes
MK_QSL
MVP
MVP
‎2014-02-20 02:49 AM

=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]))))))))))))))

660 Views
0 Likes