Data Format understanding

[Jazz2]

I want to create a dashboard of employee performance where each employee has their own data measurement metric. For example, the Head of Finance can be measured by the accuracy of forecasted revenue versus actual revenue, and an IT Assistant can be measured by the number of successful support tickets completed. All employees have different measures, and combining this data into one dataset to create a dashboard in Qlik seems impossible. Can I get help with this? Having different measurement metrics for each employee makes it challenging to have a single dataset.

[Richard_Domingos]

Hi! 

If you have a field for position you can use a IF as your expression:

If(Wildmatch(POSITION,'IT Assistant'), count(TICKET),

   If(Wildmatch(POSITION,'Head of Finance', avg(FORECAST),

     If........ ))))

By position it's possible, maybe you'll have about a hundred... but by employee it's not a good idea!

There are other ways to make it happen, variables, you can create the expression using a auxiliar table with concatenate...

[chriscammers]

First of all this approach seems contrary to the whole purpose of Qlik Sense where you provide data so a user may explore and analyze the data to discover why the KPI's are the way they are. Limiting an app to a single measure limits the possiblity of what the user can explore.

I would suggest creating several apps each with a particular subject area so users can deeply explore the data.

Now For your requirement,

I would recommend taking your data and concatenating the measures into a single field that contains all the measures. Then you can use Section Access(Row Level Security) to remove the data from the application that is not relevant to the particular user. you would probably want to have a field that identifies the measure to allow you to control the number formatting and other display options.

This could get pretty complicated and you'll have trouble serving the detail for unrelated data like finance budgets and IT Service tickets. But like I said this is not a great approach for Qlik, actually I cannot think of a tool where this would work well.

Best of Luck