Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Creator
Creator

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

<Dim1,Dim2,..>

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

View solution in original post

3 Replies
Highlighted
Master II
Master II

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

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)

Highlighted
Master III
Master III

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

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.

Highlighted
Creator
Creator

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

<Dim1,Dim2,..>

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

View solution in original post