Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Tricky Small Data Anonymisation Problem

I have several Team Leaders sharing one QV report.
The report contains KPIs of Team Members, e.g. "Number of Sales" as per Team Member.
 
Task:
1.) Every Team Leader shall see the real names of his Team Members.
2.) Names of Team Members of other teams shall be visible anonymised only. KPIs are visible normaly.
3.) A Team Leader deputising another Team Leader, shall see the real Team Member names of the deputised team additionally.
 
This is easy, e.g. you can use a calculated dimension such as

= If(Match(Team_Leader_OE,Team_Member_OE,Team_Member_Deputised_OE),Team_Member_Name, Hash128(Team_Member_Name)).
 
Problem:
Whenever a team member is being selected (in the chart of a list box), the original Team_Member_Name is being displayed in the selection status.
That's because field Team_Member_Name is part of the calculated dimension formula.
 
Target:
1.) When a real Team_Member_Name is being selected, real Team Member name shall be displayed in the selection status box.
2.) When an anomyised Team_Member_Name is being selected, anomyised Team Member name shall be displayed in the selection status box.
 
Thx and Best - Marcel
Labels (2)