topic Re: Cyclic Groups and un-accumulated % in QlikView https://community.qlik.com/t5/QlikView/Cyclic-Groups-and-un-accumulated/m-p/843573#M655469 <HTML><HEAD></HEAD><BODY><P>What expression are you using?</P><P></P><P>I would something like this:</P><P></P><P><STRONG>Avg(Aggr(YourExpression, Monthly))</STRONG></P><P></P><P>But to offer more help, need to know more details.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Mon, 29 Jun 2015 17:03:50 GMT sunny_talwar 2015-06-29T17:03:50Z Cyclic Groups and un-accumulated % https://community.qlik.com/t5/QlikView/Cyclic-Groups-and-un-accumulated/m-p/843572#M655468 <HTML><HEAD></HEAD><BODY><P>I am trying to incorporate a cyclic group for my dimension in the chart below. However, when I cycle through the group, which is defined based on different time frames such as on an annual, monthly, and quarterly basis, each time frame cumulates my expressions.</P><P><IMG alt="unfiltered.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/91189_unfiltered.png" style="height: auto; margin-right: auto; margin-left: auto; display: block;" /></P><P style="text-align: center;"><EM>Example Chart: Unfiltered</EM></P><P></P><P><IMG alt="drill.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/91196_drill.png" style="height: auto; margin-right: auto; margin-left: auto; display: block;" /></P><P style="text-align: center;"><EM>Example Chart: Filtered</EM></P><P></P><P>How can I make it so when I drill down, quarterly values displayed are not cumulative?</P></BODY></HTML> Mon, 29 Jun 2015 17:01:36 GMT https://community.qlik.com/t5/QlikView/Cyclic-Groups-and-un-accumulated/m-p/843572#M655468 2015-06-29T17:01:36Z Re: Cyclic Groups and un-accumulated % https://community.qlik.com/t5/QlikView/Cyclic-Groups-and-un-accumulated/m-p/843573#M655469 <HTML><HEAD></HEAD><BODY><P>What expression are you using?</P><P></P><P>I would something like this:</P><P></P><P><STRONG>Avg(Aggr(YourExpression, Monthly))</STRONG></P><P></P><P>But to offer more help, need to know more details.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Mon, 29 Jun 2015 17:03:50 GMT https://community.qlik.com/t5/QlikView/Cyclic-Groups-and-un-accumulated/m-p/843573#M655469 sunny_talwar 2015-06-29T17:03:50Z Re: Cyclic Groups and un-accumulated % https://community.qlik.com/t5/QlikView/Cyclic-Groups-and-un-accumulated/m-p/843574#M655470 <HTML><HEAD></HEAD><BODY><P>Opted for AVG() instead of SUM(). Thanks sunindia, again!</P></BODY></HTML> Mon, 29 Jun 2015 17:06:40 GMT https://community.qlik.com/t5/QlikView/Cyclic-Groups-and-un-accumulated/m-p/843574#M655470 2015-06-29T17:06:40Z Re: Cyclic Groups and un-accumulated % https://community.qlik.com/t5/QlikView/Cyclic-Groups-and-un-accumulated/m-p/843575#M655471 <HTML><HEAD></HEAD><BODY><P>No problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P>I am glad we were able to figure it out.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Mon, 29 Jun 2015 17:09:13 GMT https://community.qlik.com/t5/QlikView/Cyclic-Groups-and-un-accumulated/m-p/843575#M655471 sunny_talwar 2015-06-29T17:09:13Z