Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Could you please suggest me how to hide/Drop/remove column from the document.
Thanks in Advance.
Thanks,
Sherry
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.
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
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.
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
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
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
if you want to drop a column from the data model use the following syntax
Drop Filed <FiledName> From <TableName>;
Hi Sunny,
I was trying to Hide the System columns. Found answer from Sinan i am good now.
Thank you
Sharmila
Thank you Ozdemir, I was able to get results using your solution.
Thank you,
Sharmila
Thank you Grossi, i was able to fix the issue with your correction.
Thank you,
Sharmila