Custom dimension lables in selection bar - how?

[evgeniystuchalk]

Hello! I have data model with multiple fact tables, and most of field names are qualified. So teir names looks like auth_transfer.wr_name.

I want give human name to this dimension, without renaming original dimension. Like Warehouse Name.

So, i'm creating master dimension with formula =auth_transfer.wr_name. Name and title for this dimension Warehouse Name.

It looks good on visualizations, but when i'm make selection, at selection bar appears orgignal dimension name:

Is there any way to display at selection bar my dimension name instead of original?

[OmarBenSalem · Accepted solution]

When u create ur master dimension, create it as follow:

if(YourDim=YourDim,YourDim)

This way, in the filter pane, it will be shown with the new name.

If u create a master dimension without altering it, in the filter pane it will appear with its original name.

mto‌, I think this is the small "bug" that needs to be fixed

[evgeniystuchalk]

That works, thanks!

[ken4runner]

can you explain the code that you have given, and why the same item  YourDim, is listed 3 times and what it accomplishes?

[mmarchese]

It seems as though this has stopped working.  I just see "if(YourDim=YourDim,YourDim)" in the filter bar now.  Is there a solution that still works?

Edit: Actually, it does work...sometimes.  It wasn't working for me, but when I created a second dimension with the same exact formula, it worked for both that dimension and the first one.  Oh, how I love Qlik's missing basic features and associated buggy workarounds.

[naamah]

Thanks Omar, this works nice in the selection bar, but when i use sheet selection (before an active selection has been done), i cannot see the master items, i have to check "show fields" and it shows the filed name and not the master item name.