topic Re: button to switch dimensions in dimension groups in QlikView

button to switch dimensions in dimension groups

Wed, 26 Feb 2014 13:46:12 GMT

Dear all,

is it possible to have one big button to switch within dimensions in one dimension group?

If I select the dimension group, I can actually select the dimension values (the specific weeks or months)

meanwhile I would like to be able to select group week or month!

thank you!

Re: button to switch dimensions in dimension groups

marcus_sommer — Wed, 26 Feb 2014 14:00:20 GMT

Nested groups aren't possible but you could create dynamic groups which change per variable or field-selections:

- Marcus

Re: button to switch dimensions in dimension groups

Wed, 26 Feb 2014 14:05:16 GMT

Yes you can create a cyclic group from which you can change the dimensions in a chart.

Goto Properties of the chart there you will see a button "Edit Group" on left bottom. Click on that and create a new group in which you have to select the type of group as "Cyclic Group" and then add your required dimensions in that group. Then the group will appear in your dimensions tab of the properties from where you can add that Cyclic Group into the dimension and it will achieve the functionality you want.

Re: button to switch dimensions in dimension groups

Wed, 26 Feb 2014 14:13:51 GMT

guys, thank you for the answers, but I think we are a bit off, my fault.

what I would like to achieve is that instead of clicking on the small golden rounded arrow to cycle through dimensions, to have a big button on top of my dashboard where I can do that

Re: button to switch dimensions in dimension groups

marcus_sommer — Wed, 26 Feb 2014 14:29:10 GMT

To solve this with one or several (perhaps with visibilities per variables) buttons is possible but you needed beside conditions on your dimensions a additionally logik to control them. Why do you want not use the inbuilt-functionalities from qv? Perhaps you are looking for a solution for conditional dimenensions/expressions like in "Whats New in QlikView11.qvw" in sheet "Reports"?

- Marcus

Re: button to switch dimensions in dimension groups

Wed, 26 Feb 2014 14:32:06 GMT

Using button for this purpose requires a lot of effort and conditions using variable. This is possible with button but not the recommended solution.

Re: button to switch dimensions in dimension groups

Wed, 26 Feb 2014 14:36:02 GMT

I wanted this solution to satisfy user base.

Managers would like to look at KPI on a month granularity, meanwhile coordinators on a weekly granularity.

They could surely use the tiny button inbuilt in the chart, but knowing 80% of the users, they will not find it/ remember where it is etc.etc.

Having a big button with a big string "Switch week/month" would increase the userfriendliness

Re: button to switch dimensions in dimension groups

marcus_sommer — Wed, 26 Feb 2014 14:40:51 GMT

Then you need only a condition in your dimension like this: = if($(vX) = 1, Week, Month) and change with the button the variables-value from 0 to 1.

- Marcus

Re: button to switch dimensions in dimension groups

jerem1234 — Wed, 26 Feb 2014 14:47:28 GMT

Please find attached for two ways to do it. One uses loadscript by using inline table of fieldnames, while the other uses two variables. If there is only a couple of dimensions to cycle, I would do it as Marcus Sommer describes.

You can also do it via a macro, but I wouldn't advise that.

Hope this helps!

Re: button to switch dimensions in dimension groups

Wed, 26 Feb 2014 14:50:58 GMT

if I interpret correctly your answer Marcus, with your trick it won't be used the cycle group functionality, strictly speaking.

It is just a normal dimension with an if statement to toggle between the two dimensions, upon pressing the button, correct?

thank you for your help!

Re: button to switch dimensions in dimension groups

rustyfishbones — Wed, 26 Feb 2014 14:56:51 GMT

Hi Eric,

You can do this using a macro, see below, assuming here that the cyclic group is called g_DateSelection

SUB grbutton

SET gg = ActiveDocument.GetGroup("g_DateSelection")

gg.cycle 1

END SUB

You can then create a button, add an External Action, Run Macro and then add the name of the macro, in this case grbutton

Re: Re: button to switch dimensions in dimension groups

rustyfishbones — Wed, 26 Feb 2014 15:00:47 GMT

Here is a sample file that can help you

Re: button to switch dimensions in dimension groups

Anonymous — Wed, 26 Feb 2014 15:12:08 GMT

Hi Erik,

You can use cyclic groups or Drill down groups to change dimensions without changing user selections.

Object properties - Dimension Tab - Click edit group - Click add button -select Cyclic or drill down group radio button - select dimensions and click ok - click ok and select Group created and click ok in Dimension tab

Now you can change dimension by clicking on Cyclic or drill down group icon in the charts.

Re: button to switch dimensions in dimension groups

Thu, 27 Feb 2014 10:59:11 GMT

I actually

created an additional chart, where I boosted the font size for the legend.

I set transparent all the possible (background, frame, expression column)

removed title, set expression =1

so I am just left with a gigantic cyclic group button, which I can place strategically in a visible position

but thanks for your input!

Re: button to switch dimensions in dimension groups

kevinpintokpa — Wed, 12 Mar 2014 00:31:19 GMT

An unusual and innovative solution

Re: button to switch dimensions in dimension groups

sunny_talwar — Thu, 30 Oct 2014 12:22:53 GMT

Hey Alan,

I see that this Macro runs perfectly. Would you be able to explain what exactly it is doing here?

SET gg = ActiveDocument.GetGroup("g_DateSelection")

gg.cycle 1

How exactly is this switching/toggling between the fields in the cycle group?

Thanks

Re: button to switch dimensions in dimension groups

koresaket — Fri, 14 Nov 2014 06:52:22 GMT

I need to apply the same functionality on drill down group. Please suggest me some solution.