Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

hide key columns of dimension table

hello everybody,

i have two tables which are connected via the id column.

when setting up the application i have both "id" fields in the frontend available,

which may confuse a user.

is there any chance to hide the id from table A.

When commenting out the connection

between the tables is lost, which is logical.

in the end i just want the two tables connected (via id ) and

use the "description"-field of table B.

LOAD id, a_column

[table A]:...


LOAD id,description

[table B]:....

any suggestions ?

1 Reply
Highlighted
MVP & Luminary
MVP & Luminary

You could use HidePrefix to make this field treated like a system-field with something like this:

set HidePrefix='%';

and then renaming your id to %id.

- Marcus