topic Re: How to Change Dimensions by Expresions in QlikView

How to Change Dimensions by Expresions

Anonymous — Wed, 09 Dec 2015 19:16:09 GMT

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!

Re: How to Change Dimensions by Expresions

sergiorey — Wed, 09 Dec 2015 19:48:41 GMT

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.

Re: How to Change Dimensions by Expresions

Anonymous — Wed, 09 Dec 2015 19:50:55 GMT

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?

Re: How to Change Dimensions by Expresions

Anonymous — Wed, 09 Dec 2015 20:01:25 GMT

Thanks Sergio! Really useful

Re: How to Change Dimensions by Expresions

Anonymous — Wed, 09 Dec 2015 20:01:54 GMT

Thanks fchukoskie! Really useful

Re: How to Change Dimensions by Expresions

robert_mika — Wed, 09 Dec 2015 20:46:57 GMT

Another way is presented here by stevedark‌

QlikView App: Dynamic Date Dimension - With Hours

Re: How to Change Dimensions by Expresions

effinty2112 — Wed, 09 Dec 2015 21:59:03 GMT

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.

Re: How to Change Dimensions by Expresions

stevedark — Thu, 10 Dec 2015 11:35:42 GMT

Thanks for sharing the link Robert.

Re: How to Change Dimensions by Expresions

tyagishaila — Thu, 10 Dec 2015 12:03:06 GMT

Yes You can do it by using Customize Table.

Customizable Straight Table

Re: How to Change Dimensions by Expresions

tamilarasu — Thu, 10 Dec 2015 12:08:17 GMT

Hi Lucas,

The below link might be useful,

Dynamic Dimension change