topic Re: How to get % for the period not relative to total in QlikView

How to get % for the period not relative to total

rmuhammad — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 11 Oct 2017 15:28:40 GMT

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 — Wed, 11 Oct 2017 15:32:39 GMT

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 — Wed, 11 Oct 2017 16:55:16 GMT

<Dim1,Dim2,..>

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