topic Re: Ignore prefix from appearing in current selections box in QlikView

Ignore prefix from appearing in current selections box

Fri, 27 Sep 2013 15:02:56 GMT

I have developed an application using the table name as prefix in front of the field names (e.g. DATA.AGE, DATA.FULL_NAME etc).

However the Current Selections box always displays the field name, including the prefix e.g. DATA.FULL_NAME. Is there any function available that would ignore the prefix and display just the field name FULL_NAME in the Current Selections box?

Re: Ignore prefix from appearing in current selections box

Anonymous — Fri, 27 Sep 2013 15:08:51 GMT

We can only hide the fields, if they are wuth hidden preffix ot suffix. We cannot rename fields in current selection box.

Workaround - use text boxes with function GetCurrentSelections(), and use string functions (e.g. replace) and conditions to re-format the result.

Regards,

Michael