Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

nareshthavidish
Not applicable

building HR dashboard

Hi all,

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

15 Replies
Siva_Sankar
Not applicable

Re: building HR dashboard

Not applicable

Re: building HR dashboard

Hi naresh ,

What is your requirement

nareshthavidish
Not applicable

Re: building HR dashboard

my requirement is to build the employee statistics,headcount,tenure,hires,termination etc

nareshthavidish
Not applicable

Re: building HR dashboard

thanks for the response kindly have a look

my requirement is to build the employee statistics,headcount,tenure,hires,termination etc

Siva_Sankar
Not applicable

Re: building HR dashboard

prma7799
Not applicable

Re: building HR dashboard

PFA....

balrajahlawat
Not applicable

Re: building HR 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

nareshthavidish
Not applicable

Re: building HR dashboard

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

mark6505
Not applicable

Re: building HR dashboard

HI,

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.

Mark