Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Section Access - Data Reduction

Hi Folks

I have a problem in how to implement a specific requirement using data reduction in section access.

The basic concept is that every trade has a Current Trader and an Historic Trader stamped against it, our trading Desk Heads (Managers) cover teams of traders and are therefore allowed to see the data belonging to their own teams (a team is an attribute of the trader), however, they are allowed to see only their own teams depending on the role that they are viewing. So, if they are looking at historic trader role, they should be able to see all of their team data where their team is stamped against the Historic Trader, but if they are looking at Current Trader, they should then be able to see data for their teams against the current trader.

EG:

Trade IDRevenuesCurr TraderCurr Trader TeamHist TraderHist Trader Team
1000125000.00JoeAPeterB
100132000.00DaveBDaveB
100245000.00PeterBMartinC
100354000.00StuartCSharonD
100478000.00JulianATerryA
100512000.00MattBDerekC
100632000.00JoeAJoeA
100765000.00HarryCFredA
100898000.00JulieARyanB
1009226000.00NigelBNigelB

Then, I have the following Managers who are responsible for these teams:

Manager NameTeam(s)
GEORGEA
MAXB
TIMC
TONYD

Given the above information, if GEORGE is logged into the dashboard and is viewing data using the Current Trader role, he should be able to see the following trades: 1000, 1004, 1006 & 1008.  However, for the same person in the same dashboard using the same section access data reduction, if he now selects the Historic Trader role, he will now be able to see trades: 1004, 1006 & 1007.

I am pretty sure that data reduction removes data and therefore the above would be impossible to implement using data reduction.

Does anybody have any thoughts as to how this could be securely implemented?

Thanks,

Nigel.

1 Reply
Not applicable

Re: Section Access - Data Reduction

Hi Nigel,

There is no straightforward way to do what you would like to the best of my knowledge. I have come up with a workaround that may help. The caveat is a selector which has "Always one selected value" set so you always choose a role. Please use GEORGE as the Username and AAA as the password to access the attached qvw.
Kind Regards,

Footsie