Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Changing the dimensions of a Chart (Bar Chart) dynamically

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?

1 Solution

Accepted Solutions
ankit777
Specialist
Specialist

Hi

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

Try like below example.

View solution in original post

10 Replies
MK_QSL
MVP
MVP

easiest way is to create Cyclic Groups from Dimension tab.

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

agni_gold
Specialist III
Specialist III

Hi Friend

Try Ad Hoc reporting

Please see attached file , may help you ,

Anonymous
Not applicable
Author

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?

Not applicable
Author

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.

mightyqlikers
Creator III
Creator III

hi,

use conditional enabling of dimensions.

Regards

$@M

qlikviewwizard
Master II
Master II

Hi,

Please check this. Hope this will help you.

Adhoc reporting in Qlikview

ankit777
Specialist
Specialist

Hi

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

Try like below example.

Kushal_Chawda

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

MarcoWedel

Hi,

another solution could be:

QlikCommunity_Thread_180234_Pic1.JPG

QlikCommunity_Thread_180234_Pic2.JPG

QlikCommunity_Thread_180234_Pic3.JPG

QlikCommunity_Thread_180234_Pic4.JPG

QlikCommunity_Thread_180234_Pic5.JPG

hope this helps

regards

Marco