Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlickviers!
Is there a way I can change the Monthname(Day) dimension I have applied to a table as Dimension, by selecting the desired time frame in a listbox? like Days or Weeks?
In other words. If the user select Days, the table should show information open by days, and if select Week, will show it by weeks.
Currently, I change the Dimension formula everytime I need to change the timeframe, and its extremely exhausting. Or do you have a better idea of how to solve this in a different way?
Thanks!
Hi Lucas,
Try creating a cyclic group and use this group as dimension.
Go to Chart properties->Dimensions->Edit Groups
Then create a new group by adding your desired fields (In this case, Week and Day)
Finally add this group as dimension.
Hope this helps!
Regards,
Sergio.
May I suggest creating a cycle group with each of the variants that you might want, and then just allowing users to cycle the chart dimension on demand?
Thanks Sergio! Really useful
Thanks fchukoskie! Really useful
Another way is presented here by stevedark
Hi Lucas,
The cycle group idea is good. An alternative is to add all the dimensions you might need to your chart and add a condition to each of them. Add a listbox for your timeframe dimension set to have one selected value.
For your dimension 'Month' the enabling condition would be as simple as
timeframe = 'Month'
Hope this helps.
Thanks for sharing the link Robert.
Yes You can do it by using Customize Table.