Expression Legend is Missing.

[Anonymous]

Hi All,

I'm comparing current 14 months and last 14 months employee exit data.

No Employee Exit in Branding & Communication Dept in Last 14 months. Expression Legend is Missing for that dept.

No Employee Exit in National Office Dept in current 14 months but  Expression Legend is not Missing for that dept.

Please tell me how to resolve this issue.

I used following Expressions for Label

=if(Calendarmonth='April',' Apr 15 % ', 'May 15 %')

=if(Calendarmonth='April',' Apr 16 % ', 'May 16 %')

[sunny_talwar]

The attached qvw requires a User ID. Do you have sections access?

[Anonymous]

Hi Sunny,

user id: hr

Password: hr

Thanks,

Krishna

[sunny_talwar]

Try this expression for your first expression:

Alt(Round(Count({$<Year=,[Fiscal Quarter]=,Calendarmonth=,[Attrition.Attrition Reporting Month - Orginal]={'>=$(=vAttritionMonth2)<$(=vAttritionMonth1)'}>}Attrition.Emp.Id)

/Round(count({$<Year=,[Fiscal Quarter]=,Calendarmonth=,Head_Count.CDate_H={'>=$(=vHeadCountMonth2)<$(=vHeadCountMonth1)'}>}[Head_Count.Emp. Id])/14)*100)/100, 0)

[Anonymous]

Thanks Sunny.