Discussion board where members can get started with Qlik Sense.
I see how to use reductions for users, but how can I do reductions by group?
For the user it looks like...
LOAD * Inline [
ACCESS, USERID, REDUCTION
USER, DOM\admin, *
USER, DOM\user1, Proj852
REDUCTION, BrandID, ProjectID, BrandName
Proj852, 4, 852, Brand852
Proj861, 5, 861, Brand861
Proj702, 6, 702, Brand702
I think that you have to create the group table and linked to the user access table. So every user will have a group name
In the Group Table you have to create an Authrization key that linked to the Fact table
You may refer to below link by HIC
Data Reduction Using Multiple Fields