i have the append excel sheet and shall display in qlikview.
There will be no problem to get the data which will have structure
Zeiten:
Mitarbeiter(Who - similar to MA 1, MA 2 , and so on),
Datum (similar to Date, used as Base to count distinct)
...
My Problem is the analyzing of data for each MA and for each year
Additionally the Table display the department "Büro". There will be other departments too. If i am able to handle this an additionally analyzing about all departments (company wide) would be a nice extra.
Thanks a lot