topic Re: Cycle Groups - Link dimension switching between two groups? in QlikView

Cycle Groups - Link dimension switching between two groups?

ryaneverts — Thu, 31 Mar 2016 22:17:45 GMT

Hi all,

Running into a problem that hopefully the community can assist on.

Premise is as follows:

I have a chart which uses a cycle group as a dimension
The cycle group consists of date fields at day, week, year/month, and fiscal year/quarter granularity
I want to limit the data displayed in the chart to last x days/weeks/months/quarters when no date range is selected to avoid needing a dimensional scroll bar.

We tried to resolve this by creating two cycle groups (one with limited date fields, one with non-limited date fields). Using conditional logic, the limited group is shown until a date range is selected, and then the non-limited group is shown instead. We realized during testing that user experience would suffer when a date range is selected, as the two cycle groups aren't paired on which field is displayed.

My question: is there a way to pair two cycle groups so that shifting the displayed field in one cycle group will also shift the other, or do we need to try a different approach to the problem?

It seems like the currently displayed field for the group must be stored as a hidden document variable, though I'm not confident it can be accessed/changed...

Re: Cycle Groups - Link dimension switching between two groups?

swuehl — Thu, 31 Mar 2016 22:44:51 GMT

If I understand correctly, you would like to have something like a SetCurrentField() function.

Unfortunately, I don't know a method to set the current field in a dimension group.

As an alternative approach, have you considered limiting your dimension values using set expressions?

Maybe you can use a variable to create dynamically a set expression based on your current selection.

Re: Cycle Groups - Link dimension switching between two groups?

ryaneverts — Thu, 31 Mar 2016 23:56:41 GMT

Yeah, I was hoping for either a trigger I could set for OnFieldChange or something to that effect.

Sounds like you're thinking along the same lines we were, as either writing the reduction into the expression via Set analysis or using dimensional limits.

I've tried to do this with Dimensional limits previously with limited success, but I might take another crack at it to see if I can get the intended behavior, since we sometimes have several expressions per chart we might need to do this for.

Re: Cycle Groups - Link dimension switching between two groups?

amayuresh — Fri, 01 Apr 2016 03:16:52 GMT

if I understand your requirement correctly, try this,

=GetCurrentField(G1) will give you the Current Field Selected in G1 group.

You can use this function to check condition like below,

=if(GetCurrentField(G1)='Month', epression1,

if(GetCurrentField(G1)='Year',epression2,epression3))

Also this can help to compare two group field selection comparison as,

=if(GetCurrentField(G1)=GetCurrentField(G2),condition1,condition2)

to provide specific solution, can explain your requirement with example.