Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have some data and I need below output. Can anyone help me?
Questions are:
C | City |
NY | New York |
BS | Boston |
WG | Washington |
AT | Atlanta |
CG | Chicago |
D | Dallas |
SF | San Francisco |
DN | Denver |
Calculate Time spend by individual on each project.(Total days =Emenddate-emstartdate)
See attached qvw
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.
Its working fine.
Thanks a lot.............
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.
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 |
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 |
waiting for your reply
I am really waiting for your reply
Thanks,
Vijay
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.