Hiding User ID and Name in report for other users.

[ritumishra01]

we have following query 

SurgSup:
LOAD Distinct
SurgCardItemKey,
HAR,
UnknownPanelMarker,
Surgeon,
OrProcedure,
//ALL_PROC_AS_ORDERED,
ItemMfg,
ItemType,
SurgeryDate,
AmtUsed,
AmtWasted,
CostPerUnit,
AmtUsed * CostPerUnit as TotCost,
SurgLocation,
SurgFacility,
SurgInRoomDT,
SurgOutRoomDT,
Date#(Interval((SurgOutRoomDT) - (SurgInRoomDT),'m')) as ProcLength,
Interval((SurgOutRoomDT) - (SurgInRoomDT),'m') as zzzProcInterval,
SurgicalService

FROM [lib://Root/28.ValueOfCare/1.QVD/3.Load/supply_log.QVD]
(qvd);

i am trying to hide  Surgeon details in report how can i achieve that .

[MeehyeOh]

Hi, @ritumishra01 

Try HidePrefix.

HidePrefix - https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Scripting/SystemVariab...

1. add syntax in script : Set Hidefprefix = '%';

'%' Or type the character you want, such as '#'.

2. Change the name of field you want to hide to begin with the character you entered above.

3. Then that field is not displayed on the sheet.

reply, thanks

[ritumishra01]

hey thanks for your reply - i just need to hide details from one surgeon to other Example if i am surgeon i should see my name and id bit not other surgeon name and id .