topic Expression Legend is Missing. in QlikView

Expression Legend is Missing.

Anonymous — Wed, 15 Jun 2016 12:25:19 GMT

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 %')

Re: Expression Legend is Missing.

sunny_talwar — Wed, 15 Jun 2016 12:26:20 GMT

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

Re: Expression Legend is Missing.

Anonymous — Wed, 15 Jun 2016 12:31:08 GMT

Hi Sunny,

user id: hr

Password: hr

Thanks,

Krishna

Re: Expression Legend is Missing.

sunny_talwar — Wed, 15 Jun 2016 12:42:31 GMT

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)

Re: Expression Legend is Missing.

Anonymous — Wed, 15 Jun 2016 14:43:44 GMT

Thanks Sunny.