Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Refferencing the Previous Period with a Cyclic Dimension Group

Hi All,

In the attached example I have a Pivot table with two cyclic group dimension. One for Calendar fields and another for another other relevant dimensions.

Pivot.bmp

What I would like to do is add second expression that will calculate the % increase from the previous period , but still allow the user to change the calendar dimension from Month to Quarter to year to week etc. is there a way I can generically refer to to the previous period in a cyclic group dimension?

Many thanks

Lawrence

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

hei

attach is an example

it uses above functio

on quick check it seems to work

hope it helps you

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hei

attach is an example

it uses above functio

on quick check it seems to work

hope it helps you

Not applicable
Author

Thanks Liron,

I never new those functions existed, you certainly enlighted me to a whole new area of QV. I was trying to use GetCurrentField() within set Analysis, but your method is far simplier.

Many thanks again,

Lawrence