topic Changing the dimensions of a Chart (Bar Chart) dynamically in QlikView

Changing the dimensions of a Chart (Bar Chart) dynamically

Anonymous — Fri, 11 Sep 2015 18:42:39 GMT

I have 3 fields (preferably dimensions) called A,B,C.

I want to create a Bar Chart where by default, A should be the dimension. When user Clicks a button named (A)/B/C, the chart should change it's dimension respectively.

P.S.: I tried the above by creating 3 different Charts with A,B,C as dimensions separately and then set the variable for each button to show the chart using Conditional option under Layout Tab.

I feel, that is not the right way of doing it. Is there any alternative to do this?

Re: Changing the dimensions of a Chart (Bar Chart) dynamically

MK_QSL — Fri, 11 Sep 2015 19:47:54 GMT

easiest way is to create Cyclic Groups from Dimension tab.

Use Edit Groups >> New >> Add A, B and C as Dimensions..

Re: Changing the dimensions of a Chart (Bar Chart) dynamically

agni_gold — Fri, 11 Sep 2015 20:07:58 GMT

Hi Friend

Try Ad Hoc reporting

Please see attached file , may help you ,

Re: Changing the dimensions of a Chart (Bar Chart) dynamically

Anonymous — Mon, 14 Sep 2015 05:03:52 GMT

Hi Manish,

User doesn't want Cyclic group instead a button is needed for each dimension.

The simple thing I could try is clone the chart and change the dimension for each chart and put a Conditional Show for all the charts. But is there any alternative to doing this?

Re: Changing the dimensions of a Chart (Bar Chart) dynamically

Mon, 14 Sep 2015 05:19:05 GMT

Hi,

Your way is correct create 3 different Bar charts and, create 3 variables, using this variables give the conditions to the button and also use this variable in the chart in the layout tab conditional box using the getfieldselection() function,and whenever required then only show or else hide it.

Re: Changing the dimensions of a Chart (Bar Chart) dynamically

mightyqlikers — Mon, 14 Sep 2015 05:33:51 GMT

hi,

use conditional enabling of dimensions.

Regards

$@M

Re: Changing the dimensions of a Chart (Bar Chart) dynamically

qlikviewwizard — Mon, 14 Sep 2015 06:01:38 GMT

Hi,

Please check this. Hope this will help you.

Adhoc reporting in Qlikview

Re: Changing the dimensions of a Chart (Bar Chart) dynamically

ankit777 — Mon, 14 Sep 2015 07:45:51 GMT

You can do this using one chart itself. Just enable condition for each dimension and manage this using a variable.

Try like below example.

Re: Changing the dimensions of a Chart (Bar Chart) dynamically

Kushal_Chawda — Mon, 14 Sep 2015 07:56:29 GMT

Please see the attached.

See the trigger set

Ducument Properties->Triggers->Document Event Trigger->On Open

This trigger is set to display default dimension on chart.

Rest all is just set variable condition on button

Re: Changing the dimensions of a Chart (Bar Chart) dynamically

MarcoWedel — Mon, 14 Sep 2015 10:33:18 GMT

Hi,

another solution could be:

hope this helps

regards

Marco

Re: Changing the dimensions of a Chart (Bar Chart) dynamically

Sagar082 — Mon, 15 Jun 2020 11:35:18 GMT

Hi Marcowedel,

Greeting for the day. You made my day! Thank for beautiful and simple solution.

Regrads,

Sagar.