Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Cyclic Groups and un-accumulated %

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.

unfiltered.png

Example Chart: Unfiltered

drill.png

Example Chart: Filtered

How can I make it so when I drill down, quarterly values displayed are not cumulative?

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: Cyclic Groups and un-accumulated %

What expression are you using?

I would something like this:

Avg(Aggr(YourExpression, Monthly))

But to offer more help, need to know more details.

Best,

Sunny

3 Replies
sunny_talwar
Not applicable

Re: Cyclic Groups and un-accumulated %

What expression are you using?

I would something like this:

Avg(Aggr(YourExpression, Monthly))

But to offer more help, need to know more details.

Best,

Sunny

Not applicable

Re: Cyclic Groups and un-accumulated %

Opted for AVG() instead of SUM(). Thanks sunindia, again!

sunny_talwar
Not applicable

Re: Cyclic Groups and un-accumulated %

No problem

I am glad we were able to figure it out.

Best,

Sunny