If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
Hi, during the data load i would like to create a new field based on various user attributes, for example
Table 1UserID, RoleUserA, AdminUserA, UserUserB, UserUserC, AdminUserC, DBAUserC, User
UserID, ClassUserA, BaseUserB, SuperUserC, Super
What i would like to do is create the following additional table
Where the Priority is 1, if the total number of User Entries (regardless of role) in table 1 is > 0 AND the Table2 Class is Super,
if not, then if the User Entries table 1 > 0 but class is not super, then set priority to 2, if not then set entry to 3.
Whats the best way to accomplish something like this, the ultimate goal to have a priority assigned to each user based on the data in table 1 and 2 for that user.