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: 
danialier
Creator III
Creator III

Column and Pie Chart

Hello,

I have a Chart with the revenue for several countries. In this chart you can move from a column view to a pie view.

I want to the column view to show the columns in terms of revenue in numbers. However when jumping to the pie view, I want it to show the revenue in percentage (not in numbers).

Is that possible ? So this is to display revenues in numbers when visualizing the chart in columns and to display revenues in percentage when visualizing the chat in a pie ?

Thanks,

Dani

1 Solution

Accepted Solutions
Gysbert_Wassenaar

Perhaps with a macro. But an easier and more robust option is to use two chart objects, one column chart and one pie chart, and show/hide these as needed. You can use the Conditional option on the Layout tab in combination with a variable. You can use a button or text box with a Set Variable action to toggle the value of the variable.

variable: vShowPie (with initial value 0)

Conditional expression of the pie chart: =vShowPie

Conditional expression of the column chart: =NOT vShowPie

Set Variable action: set the variable vShowPie to the value =Not vShowPie


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

Perhaps with a macro. But an easier and more robust option is to use two chart objects, one column chart and one pie chart, and show/hide these as needed. You can use the Conditional option on the Layout tab in combination with a variable. You can use a button or text box with a Set Variable action to toggle the value of the variable.

variable: vShowPie (with initial value 0)

Conditional expression of the pie chart: =vShowPie

Conditional expression of the column chart: =NOT vShowPie

Set Variable action: set the variable vShowPie to the value =Not vShowPie


talk is cheap, supply exceeds demand
morganaaron
Specialist
Specialist

As far as I'm aware, you're not able to do something like this based on a fast change (which I assume you're using?).

Another option would be to create two charts, and use a conditional show/hide to flip between them, so you could have the different expressions in each and use a button/textbox to toggle between them.

maxgro
MVP
MVP

see attachment