topic Re: How do I have a dynamic dimension in a cyclic group? in QlikView

How do I have a dynamic dimension in a cyclic group?

Fri, 01 Nov 2013 10:17:49 GMT

Hi. I have a qvw file where I allow the users to switch between fiscal and calendar years. The selection is stored in a variable and I use the following calculated dimension in my charts to display either date dimension depending on the selection.

if(vViewMode='Fiscal',FiscalPeriod,Month)

I'm trying to use the same calculated dimension in a cyclic group but I just get '-' instead of the dimension. What am I doing wrong?

Thanks in advance.

Re: How do I have a dynamic dimension in a cyclic group?

Nicole-Smith — Fri, 01 Nov 2013 14:10:27 GMT

If you're using a cyclic group for your dimension, you shouldn't use the calculated dimension you have listed above. You should have two dimensions in the cyclic group: one being FiscalPeriod and the other being Month.

Re: How do I have a dynamic dimension in a cyclic group?

Fri, 01 Nov 2013 14:30:10 GMT

Thanks for replying but I'd rather the users didn't have to cycle through options they didn't want.

Re: How do I have a dynamic dimension in a cyclic group?

Fri, 01 Nov 2013 14:35:44 GMT

Hurrah. I've just figured out how to do it!

I've created a variable vViewMonth with the following value

=if(vViewMode='Fiscal','FiscalPeriod','Month')

I then set the dimension in the group to be =$(vViewMonth) and the label to =vViewMonth