How to Change Dimensions by Expresions

[Anonymous]

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!

[sergiorey]

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.

[Anonymous]

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?

[Anonymous]

Thanks Sergio! Really useful

[Anonymous]

Thanks fchukoskie! Really useful

[robert_mika]

Another way is presented here by stevedark‌

QlikView App: Dynamic Date Dimension - With Hours

[effinty2112]

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.

[stevedark]

Thanks for sharing the link Robert.

[tyagishaila]

Yes You can do it by using Customize Table.

Customizable Straight Table

[tamilarasu]

Hi Lucas,

The below link might be useful,

Dynamic Dimension change