Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hii
In Qlikview I Want to create view like http://community.qlik.com/message/163026#163026
I am attaching EMP.XLS which as DOJ (Date of join) and DOL (date of leaving) and s_active
for Active/In-Active.
Can you give guide me how to achieve the same in Qlikview.
Vikas
Hi,
Vikas can you explain a bit more on this?
What are the definitions of below things and how they are calculated
1) opening
2) Joinies
3) Resignies
4) Closing.
Is table shown above is what you are expecting?
In not provided the expected output.
Regards
ASHFAQ
Are you numbers from the table just random one or correlated to your data?
Does the blue color in the table have any meaning?
Hii,
Robert Thanks
1 Are you numbers from the table just random one or correlated to your data?
Ans Dummy nos , Actual nos will come from EMP.XLS
2 Does the blue color in the table have any meaning?
Ans : No meaning it is appeared while copy from excel sheet.
Please provide me solution.
Vikas
Whene user will select 2013-14 Period ( 1-4-2013 to 31-3-2014) fin year then
opening < 1.4.2013
Joinies >=1.4.2013 to 31.3.2014 ( full fin year if selected year)
Resignies >=1.4.2013 to 31.3.2014 ( full fin year if selected year)
Closing = Opening + Joinies - Resignies ( up to 31-3.2014)
When user will select fin year 2014-2015 then closing of 31.3.2014 will be appeared in
opening head count. Logic will be same for Qtr / Month
Please tell me more information you required for the same
Vikas
Can you give real numbers for let say Grade "A1"
Opening
Joinies
Resignies
Closing
Dear Robert,
1. EMP.XLS is attached from live data only emp names are changed to XYZ/PQR like this and actual grades are available in excel.
2. Whene user will select 2013-14 Period ( 1-4-2013 to 31-3-2014) fin year then
opening < 1.4.2013
Joinies >=1.4.2013 to 31.3.2014 ( full fin year if selected year)
Resignies >=1.4.2013 to 31.3.2014 ( full fin year if selected year)
Closing = Opening + Joinies - Resignies ( up to 31-3.2014)
When user will select fin year 2014-2015 then closing of 31.3.2014 will be appeared in
opening head count. Logic will be same for Qtr / Month
Dear Robert
Do you require more information ???
Vikas
Dear Ashfaq
Do you require more information ???
Vikas
Did you working on the same ???
Thanks
Vikas