QlikView App Dev

[rmuhammad]

Hi

How do I get % for the each period(100%) not relative to over all total?

Count( {<YEAR, MONTH, Period={">=$(=Date(MonthStart(Max(Period),-13)))  <=$(=Date(Max(Period)))"}>}  EMPLID)

/ Count( {<YEAR, MONTH, Period={">=$(=Date(MonthStart(Max(Period),-13)))  <=$(=Date(Max(Period)))"}>}TOTAL    EMPLID)

[devarasu07]

Like this?

Count( {<YEAR, MONTH, Period={">=$(=Date(MonthStart(Max(Period),-13)))  <=$(=Date(Max(Period)))"}>}  EMPLID)

/ Count( {<YEAR, MONTH, Period={">=$(=Date(MonthStart(Max(Period),-13)))  <=$(=Date(Max(Period)))"}>}TOTAL  <YEAR, MONTH> EMPLID)

[antoniotiman]

Hi,

try this

/ Count( {<YEAR, MONTH, Period={">=$(=Date(MonthStart(Max(Period),-13)))  <=$(=Date(Max(Period)))"}>}TOTAL <Dim1,Dim2,..>  EMPLID)

try to add all Dimwnsions which You have in Group.

[rmuhammad · Accepted solution]

<Dim1,Dim2,..>

Finally it worked when I have added <YEAR,MONTH,Period>