Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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
Highlighted
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
Highlighted
MVP
MVP

easiest way is to create Cyclic Groups from Dimension tab.

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

Highlighted
Specialist III
Specialist III

Hi Friend

Try Ad Hoc reporting

Please see attached file , may help you ,

Highlighted
Creator III
Creator III

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?

Highlighted
Not applicable

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.

Highlighted
Creator III
Creator III

hi,

use conditional enabling of dimensions.

Regards

$@M

Highlighted
Master II
Master II

Hi,

Please check this. Hope this will help you.

Adhoc reporting in Qlikview

Highlighted
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

Highlighted
MVP
MVP

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

Highlighted

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