Discussion Board for collaboration on QlikView Scripting.
kindly help me out as i'm not able to do scripting part that is data model to build hr dashboard
i'm sending my data tables have a look and try to help me build dashboard
Community peoples assist you if you face any challenge. No one is here who can prepared a dashboard for you.
But yes, if you are facing any challenge then let us know. making it simpler:
For Employee statistic, Headcount: Employee ID is required
For Tenure/Hire : Date Of Joining required
For Termination: Date of Terminate required
thanks for the reply shankarece as i'm bit weak in the scripting part so i asked help me out
i got tables like employee,employee details,internal candidate,external candidate,time period,designation etc so where exactly i need to start to build a proper datamodel as i attached a screen shot of my datamodel when all the tables are loaded in the qlikview kindly have a look
There is a lot that can be done with the data model as a start as in optimization, if you have a search of the forum there is plenty of information.
Also I would take a look at the different training available both on-line and courses, would really help you with building a dashboard. There might be too much to address in one discussion.
Not knowing the data or how client/user want to visualise the data it is hard to advise.
One simple one for head count would be Something like COUNT(Distinct EmpID), I say use distinct as i don't know the data and there could be duplicates.