topic Re: Cyclic Dimension in QlikView

Cyclic Dimension

Wed, 15 Oct 2014 09:03:33 GMT

Hi everyone,

I have several charts in my dashboard. (Almost) all of them have a cyclic dimension in it: Time, that splits Years, into Quaters, into Months.

I would like to have the cyclic-dimension button only ONCE on my tab, instead of in every single chart.

I already managed to remove it from my charts; but right now my users would not be able to change the time-dimension at all.

Can anyone help me with this?
Thanks,
Lina

Re: Cyclic Dimension

datanibbler — Wed, 15 Oct 2014 09:09:27 GMT

Hi Lina,

you can just remove the cyclic group from your charts and replace it by several individual dimensions, with each one becoming active only when a variable you have created befforehand has a specific value.

=> Then you can easily add a button to your sheet to control that variable

=> The button will then control the dimensions in all of your charts simultaneously, so they will all show the same dimension.

I do that always when I have several possible dimensions because the target_group to use my apps is made up of - well, non-techies in any case ...

HTH

best regards,

DataNibbler

Re: Cyclic Dimension

martinpohl — Wed, 15 Oct 2014 09:11:40 GMT

Hello Lisa,

create a table within year, qaurter and month

Show the field in a listbox.

Use the selected value from the listbox as the dynamic dimension on your charts.

Dimension:

Re: Cyclic Dimension

c_gilbert — Wed, 15 Oct 2014 09:16:33 GMT

I encountered a similar problem. All I did was create a blank straight table chart with the same cyclic dimension, then resized it so you could only see the cyclic icon, and put that somewhere else.

I will try to upload a sample qvw if you'd like.

Re: Cyclic Dimension

Anonymous — Wed, 15 Oct 2014 09:16:50 GMT

Check the following thread for some alternatives that are quite nice. Basically your options are:

1. Macro

2. Dynamic Dimension

3. Erik's creative idea the bottom

button to switch dimensions in dimension groups

Kind regards

Niklas

Re: Cyclic Dimension

mdmukramali — Wed, 15 Oct 2014 09:18:13 GMT

Dear,

workaround .

find the attached file.

Thanks,

Mukram