topic Hide columns in QlikView

Hide columns

Sat, 27 Jun 2015 19:44:08 GMT

Hi Gurus,

I have designed data model by joining OperatingUnit table with fact table which has opertg_unit_key as primary key column. But user doesnt want to see opertg_unit_key( key columns which used to join table ). By searching over youtube, i tried implementing following code, which doesnt work.

SET HidePrefix = '~'
ODBC CONNECT32 TO [dw-xlre-am] (UserId is crystal, Password is password);
OperatingUnit:
LOAD OperatingUnitDesc,
opertg_unit_key AS [~opertg_unit_key]
FROM
(qvd);

Could you please suggest me how to hide/Drop/remove column from the document.

Thanks in Advance.

Thanks,

Sherry

Re: Hide columns

sunny_talwar — Sat, 27 Jun 2015 19:55:35 GMT

Where exactly are you trying to hide it from? From a specific table or from the database? Need more information before we can guide you in the right direction.

Best,

Sunny

Re: Hide columns

sinanozdemir — Sat, 27 Jun 2015 20:14:08 GMT

Hi Sharmila,

Here is my solution:

I used a different symbol, maybe QlikView doesn't like '~'. After that in the front end sheet properties, just uncheck "Show System Fields"

As you can see "Specialty" field is hidden.

Hope this helps.

Re: Hide columns

maxgro — Sat, 27 Jun 2015 20:28:45 GMT

the problem in your script is you forget a ;

replace

SET HidePrefix = '~'

with

SET HidePrefix = '~';

some different way

1) HidePrefix (or HideSuffix), as you did in your script; from QlikView help

HidePrefix

All field names beginning with this text string will be hidden in the same manner as the system fields. A user-defined variable.

Example:

set HidePrefix='_' ;

If this statement is used, the field names beginning with an underscore will not be shown in the field name lists when the system fields are hidden.

2) mapping table

you can add the description to fact table using a mapping load and applymap function

MapOperatingUnit:

mapping load

opertg_unit_key, OperatingUnitDesc

FROM (qvd);

facttable:

load

.......,

ApplyMap ('MapOperatingUnit', opertg_unit_key ) as OperatingUnitDesc,

......

from

.......;

In 1 you have an hidden field, a fact table and a lookup table

In 2 you don't have the field and the lookup table, only the fact table

Re: Hide columns

svenkita — Mon, 29 Jun 2015 05:28:58 GMT

if you want to drop a column from the data model use the following syntax

Drop Filed <FiledName> From <TableName>;

Re: Hide columns

Wed, 22 Jul 2015 18:59:33 GMT

Hi Sunny,

I was trying to Hide the System columns. Found answer from Sinan i am good now.

Thank you

Sharmila

Re: Hide columns

Wed, 22 Jul 2015 19:01:08 GMT

Thank you Ozdemir, I was able to get results using your solution.

Thank you,

Sharmila

Re: Hide columns

Wed, 22 Jul 2015 19:09:54 GMT

Thank you Grossi, i was able to fix the issue with your correction.

Thank you,

Sharmila