Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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>