topic Re: Employee Data in QlikView

Employee Data

Anonymous — Wed, 15 Oct 2014 16:35:58 GMT

Hi All,

I have some data and I need below output. Can anyone help me?

Questions are:

In department Table In location column replace the abbreviation with whole name:-

C	City
NY	New York
BS	Boston
WG	Washington
AT	Atlanta
CG	Chicago
D	Dallas
SF	San Francisco
DN	Denver

Calculate commission of the employees.
1. a. Commission should be 15% of their salary if they are more than 40 yrs in organization.
2. b. Commission should be 10% of their salary if they are more than 30 yrs in organization.
3. c. Commission should be 5% of their salary if they are less than 30 yrs in organization.

Calculate Time spend by individual on each project.(Total days =Emenddate-emstartdate)

Re: Employee Data

Gysbert_Wassenaar — Wed, 15 Oct 2014 16:56:07 GMT

See attached qvw

Re: Employee Data

Anonymous — Wed, 15 Oct 2014 17:05:26 GMT

Its right but I have one question:

Why we should not take all the tables in Emp_P_Data in it another sheet also present.

Re: Employee Data

Anonymous — Wed, 15 Oct 2014 17:15:27 GMT

Its working fine.

Thanks a lot.............

Re: Employee Data

Gysbert_Wassenaar — Wed, 15 Oct 2014 17:16:56 GMT

The example contains only the two tables that were necessary to answer your two questions. If you need the data from the other tables to satisfy your real business requirements then you should load them.

Re: Employee Data

Anonymous — Wed, 15 Oct 2014 17:21:35 GMT

I want one more outputs like

Show full name in list box, and on selection it should aslo show the related data
calculate experience of each employee
count of projects started in particular month.
what other analysis can you do from given data. Create appropriate object for that.
Show how many people were hired in a month.
assume cuuernt date as maximum date available in data, calculate YTD, MTD for current year and previous year

Re: Employee Data

Anonymous — Wed, 15 Oct 2014 17:37:44 GMT

I want one more outputs like

Show full name in list box, and on selection it should aslo show the related data
calculate experience of each employee
count of projects started in particular month.
what other analysis can you do from given data. Create appropriate object for that.
Show how many people were hired in a month.
assume cuuernt date as maximum date available in data, calculate YTD, MTD for current year and previous year

Employee Data

Re: Employee Data

Anonymous — Wed, 15 Oct 2014 18:05:32 GMT

waiting for your reply

Re: Employee Data

Anonymous — Wed, 15 Oct 2014 18:52:51 GMT

Hey Gysbert

I am really waiting for your reply

Thanks,

Vijay

Re: Employee Data

Gysbert_Wassenaar — Thu, 16 Oct 2014 11:23:17 GMT

Perhaps you should start by learning how to use Qlikview yourself instead of demanding that other people build your solutions for you. Please go to QlikView Free Training - Business Intelligence (BI) Reporting Software Solutions | Qlik and educate yourself first.