Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Please find attached QVW and try to make an expression in same bar chart.
Now I have to 2 expression in BAR Chart.
DOJ =Count(DISTINCT If(MonthEnd(Link_Date)=Monthend(DOJ),EmpCode))
DOL =Count(DISTINCT If(MonthEnd(Link_Date)=Monthend(DOL1) AND DOL1<>'01/01/1900',EmpCode))
I have Total Head Count till Date = 4718, Expression is
=Count({<DOL1={'01/01/1900', ">=$(=Today())"}>} DISTINCT EmpCode)
Now I have to make an expression in backward for month wise like this.
For June – 4718
For May - (4718 + June Month DOL -June Month DOJ) = Like (4718 + 16 – 5) = 4729
For April - (4729+ May Month DOL -May Month DOJ) = Like (4729+ 69 – 40) = 4758
Thanks.
Hi Dinesh,
Output is correct, Can u build the same in my QVW. Backyear month will follow the same.
Please find the attached QVW.
Thanks