topic Re: building HR dashboard in QlikView

building HR dashboard

nareshthavidishetty — Tue, 01 Dec 2015 10:03:19 GMT

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

Re: building HR dashboard

Siva_Sankar — Tue, 01 Dec 2015 10:08:48 GMT

Usage Guidelines for Qlik Community

Re: building HR dashboard

Tue, 01 Dec 2015 10:09:18 GMT

Hi naresh ,

What is your requirement

Re: building HR dashboard

nareshthavidishetty — Tue, 01 Dec 2015 10:10:39 GMT

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

Re: building HR dashboard

nareshthavidishetty — Tue, 01 Dec 2015 10:11:17 GMT

thanks for the response kindly have a look

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

Re: building HR dashboard

Siva_Sankar — Tue, 01 Dec 2015 10:13:11 GMT

QlikCommunity Tip: How to get answers to your post?

Re: building HR dashboard

prma7799 — Tue, 01 Dec 2015 10:15:17 GMT

PFA....

Re: building HR dashboard

Anonymous — Tue, 01 Dec 2015 10:16:51 GMT

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

Re: building HR dashboard

nareshthavidishetty — Tue, 01 Dec 2015 10:21:08 GMT

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

Re: building HR dashboard

Mark_Little — Tue, 01 Dec 2015 10:21:43 GMT

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

Re: building HR dashboard

nareshthavidishetty — Tue, 01 Dec 2015 10:22:41 GMT

thanks balraj ahlawat i vll try what u mentioned

Re: building HR dashboard

nareshthavidishetty — Tue, 01 Dec 2015 10:24:14 GMT

yea i already did the count for employee mark

thanks for the reply

Re: building HR dashboard

prma7799 — Tue, 01 Dec 2015 10:27:17 GMT

Hi Naresh ,

With the help of that attachment you can achieve at least something.

Please refer it.

balrajahlawat

I agree with you.

Thanks

Re: building HR dashboard

nareshthavidishetty — Tue, 01 Dec 2015 10:31:51 GMT

thanks qlikview7799 for the reply

yea i vll try to find what balraj suggested

Re: building HR dashboard

Anonymous — Tue, 01 Dec 2015 10:33:31 GMT

Good

Re: building HR dashboard

prma7799 — Tue, 01 Dec 2015 10:35:17 GMT

Good. But refer that attachment.