variable values picking wrong

Anonymous — Sat, 21 May 2016 08:18:17 GMT

HI All,

I created variables. if I click on Audit & Assurance and Staff variable values picking wrong. I'm getting more than 100% in graph.

More than 100 % is wrong. Head count table having data for every month. Attrition table not having data for all months.(No employee exit in some months) Head count variables picking correct and Attrition variables picking wrong while selecting filters.

I need Attrition 14 months data and Head count 14 months data .

Mar'2014 to Apr'2015 ....Last 14 Months

Mar'2015 to Apr'2016......Current 14 Months

(In HR terms Attrition = Employee Exit)

Rolling Attrition = 14 Months Attrition Emp count/Avg Head count.

Avg Head count= 14 Months Head count/14

Variables:

vAttritionMonth=AddMonths(Max([Attrition.Attrition Reporting Month - Orginal]),-13)

vAttritionMonth1=AddMonths(Max([Attrition.Attrition Reporting Month - Orginal]),-11)

vAttritionMonth2=AddMonths(Max([Attrition.Attrition Reporting Month - Orginal]),-25)

vHeadCountMonth=AddMonths(Max(Head_Count.CDate_H),-13)

vHeadCountMonth1=AddMonths(Max(Head_Count.CDate_H),-11)

vHeadCountMonth2=AddMonths(Max(Head_Count.CDate_H),-25)

Expressions:

Round(Count({$<[Attrition.Attrition Reporting Month - Orginal]={'>=$(=vAttritionMonth2)<$(=vAttritionMonth1)'}>}Attrition.Emp.Id)
/Round(count({$<Head_Count.CDate_H={'>=$(=vHeadCountMonth2)<$(=vHeadCountMonth1)'}>}[Head_Count.Emp. Id])/14)*100)/100

=Round(count({$<[Attrition.Attrition Reporting Month - Orginal]={'>=$(=vAttritionMonth)'}>}Attrition.Emp.Id)/
(count({$<Head_Count.CDate_H={'>=$(=vHeadCountMonth)'}>}[Head_Count.Emp. Id])/14)*100)/100

Dimension

FunctionOthers

Filters:

FunctionOthers

Grade

Thanks,

Krishna.

Re: variable values picking wrong

Gysbert_Wassenaar — Sun, 22 May 2016 15:12:14 GMT

You divide the headcount by 14 to get a monthly average headcount. But you don't divide the attrition count by any number of months. That's why you get funny numbers.

topic variable values picking wrong in QlikView

variable values picking wrong

Re: variable values picking wrong