How to show labeled names in CURRENT SELECTİONS

[#1]

Hi,

I need to show the labeled names in current selections instead of origional names. For example: 'PL2_name' is original name I want to make show 'ProductGroup' instead. How Can I do this? Help please

Thanks

Regards

[JonnyPoole]

You may have to build a 'custom current selections box' by using a text box with the getcurrentselections() function

Example below.

Here i'm also using replace() to replace 'NewMonth' with another string 'OriginalMonth' which happens to be the original field name.

[#3]

Jonathan

I couldnt get how to apply it exactly?

[JonnyPoole]

Here is a sample.

If you can open it then here are steps:

1. Create a new text box. Use horizontal=left and vertical=top alignment

2. in the text area, enter the expression:   getcurrentselections()

....this will show all current selections. test it out by selecting a few selections.

3. then , change the expression to replace the field name you want to change in the display with the new field name. Like this:

=replace( GetCurrentSelections(),'NewMonth','OriginalMonth')

[#5]

Jonathan

Thanks for the help. But it is not that useful maybe for me. Thanks for şt anyway but cannnot apply the project.

[trdandamudi]

You can create a table as below with all your original names and labeled names and this should give you the desired result...

Load * as [

Original_Name, Labelled_Name

PL2_Name, ProductGroup

OriginalMonth, NewMonth
];

[luciancotea]

Best solution is to rename the actual fields in the data model. You can use a mapping file to rename all the field in one shot at the end.

See "Rename fields" syntax

[rajkumarb]

HI Kezban

Hope this helps

[Gabriel]

Hi,

I think if you have a spreadsheet with all the Field Name you wish to rename as they are coming from source in one column and have another column next to that as User Friendly Name, then bring this spreadsheet into your data model as MAPPING Table before your FACT table, then after you've loaded your FACT table just use RENAME FIELDS USING MAPPING_TABLE_NAME.

This will ensure that those fields in the Mapping table have user friendly name in current selection box.

You can also do this (instead of spreadsheet) with INLINE TABLE

[#10]

Hi,

that's not possible as CS box doesn't provide this functionality. Still you have several ways to create a workaraound:

1. Rename your filed in LOAD statement:

LOAD PL2_name as ProductGroup ...

2. Use RENAME FILEDS. See here QlikView Addict: User friendly field names in QlikView

3. Use extensions. For example: http://www.qlikblog.at/2412/qliktip-better-current-selections-box-translate-hide-fields/

Hope that helps!