topic Re: Cyclic Group on Dimension Axis in QlikView

Cyclic Group on Dimension Axis

Fri, 29 Nov 2013 11:58:40 GMT

Hi All,

Hope someone can help with this.. I have a cyclic group compromising of FiscalYear, QtrYear and ShipDate that I use in a Bar chart. I modified the Dimension axis for this chart, adding "Min (FiscalYear) " and "Max (FiscalYear) " to the Static Min and Max fields. As a result, when I cycle past the FiscalYear in my chart I get no data since the Axes are set to FiscalYear. How can I modify the axes to work with the Qtr and Month selections?

All help much appreciated

John

Re: Cyclic Group on Dimension Axis

sujeetsingh — Fri, 29 Nov 2013 12:03:51 GMT

create another group with these added dimensions

Re: Cyclic Group on Dimension Axis

Fri, 29 Nov 2013 12:10:39 GMT

But even if I create another group, my Dimension Static Min and Static Max are still set to "Min (FiscalYear) " and "Max (FiscalYear)" .. Is there an expression that I could use in the Static Min/Max box to dynamically allow the Cyclic group?

Re: Cyclic Group on Dimension Axis

Fri, 29 Nov 2013 12:11:38 GMT

Hi,

sorry but your question not clear.....are you adding two more field with cyclic group dimension??

Can you please attach any sample file?

Regards,

Ashutosh

Re: Cyclic Group on Dimension Axis

ngulliver — Fri, 29 Nov 2013 12:28:22 GMT

One option would be to use buttons instead of cycle groups. The button could change the dimension and the Static Max /Min if they were all in variables.

Regards,

Neil