Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Nested groups aren't possible but you could create dynamic groups which change per variable or field-selections:
- Marcus
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.
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
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
Using button for this purpose requires a lot of effort and conditions using variable. This is possible with button but not the recommended solution.
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
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
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!
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!