Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Jonathan
I couldnt get how to apply it exactly?
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')
Jonathan
Thanks for the help. But it is not that useful maybe for me. Thanks for şt anyway but cannnot apply the project.
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
];
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
HI Kezban
Hope this helps
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
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!