Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

View solution in original post

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