Qlik Community

Qlik DataMarket Discussions

Discussion Board for collaboration regarding Qlik DataMarket.

Not applicable

Hide NTNAME Field from current selection box

Hi all,

I have created section access script on which only registered user can access qlikview documents by matching NTNAME. It means that if my NTNAME is NAVEEN(CAPITAL LETTER) then it will match NAVEEN NTNAME from the table and access will be granted. I am also maintaining sheet level access by matching NTNAME. So, by default it is selecting NTNAME Who login through machine. In dashboard, i am using current selection box. In current selection box this NTNAME Value is automatically comes. But i want to hide this NTNAME field value from current selection box. I have already used hideprefix option but it is not working. When I am using hideprefix then sheet level access function is not working properly. So please help me to hide NTNAME field from current selection box but NTNAME value should be work for section access. Thanx in advance. 

1 Solution

Accepted Solutions
Not applicable

Re: Hide NTNAME Field from current selection box

The script is below:::::

Section Access;

LOAD ACCESS,

     USER_TYPE,

     NTNAME

FROM

Sheetlevelaccess.xlsx

(ooxml, embedded labels, table is UserList);

Section Application;

Combined_table:

LOAD

USER_TYPE,

    sheet1,

    sheet2,

    sheet3

    

FROM

Sheetlevelacces.xlsx

(ooxml, embedded labels, table is AccessType);

Join

LOAD USER_TYPE,

     NTNAME

FROM

Sheetlevelacces.xlsx

(ooxml, embedded labels, table is UserList);

4 Replies
morganaaron
Valued Contributor

Re: Hide NTNAME Field from current selection box

Naveen,

A section access table shouldn't be viewable in the front end - can you post your script? This should only be the case if you're loading the NTNAME as a field in your application section as well as your access.

Not applicable

Re: Hide NTNAME Field from current selection box

The script is below:::::

Section Access;

LOAD ACCESS,

     USER_TYPE,

     NTNAME

FROM

Sheetlevelaccess.xlsx

(ooxml, embedded labels, table is UserList);

Section Application;

Combined_table:

LOAD

USER_TYPE,

    sheet1,

    sheet2,

    sheet3

    

FROM

Sheetlevelacces.xlsx

(ooxml, embedded labels, table is AccessType);

Join

LOAD USER_TYPE,

     NTNAME

FROM

Sheetlevelacces.xlsx

(ooxml, embedded labels, table is UserList);

MVP
MVP

Re: Hide NTNAME Field from current selection box

another way to hide a field in current selection is

TAG FIELD myfield with '$hidden';


replace myfield with NTNAME


Not applicable

Re: Hide NTNAME Field from current selection box

hi maxgro,

Now i am able to hide the NTNAME Field from current selection box and everything is working correctly. Very very thank you. 

Community Browser