Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
rmuhammad
Creator
Creator

How to get % for the period not relative to total

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)

%.png

1 Solution

Accepted Solutions
rmuhammad
Creator
Creator
Author

<Dim1,Dim2,..>

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

View solution in original post

3 Replies
devarasu07
Master II
Master II

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
Master III
Master III

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
Creator
Creator
Author

<Dim1,Dim2,..>

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