BAR CHAR EXPRESSION

[sona_sa]

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.

[dineshm030]

https://community.qlik.com/t5/QlikView-App-Dev/BAR-CHART/td-p/1818492

[sona_sa]

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