topic Re: Column and Pie Chart in QlikView

Column and Pie Chart

danialier — Fri, 09 Jan 2015 15:45:47 GMT

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

Re: Column and Pie Chart

Gysbert_Wassenaar — Fri, 09 Jan 2015 15:56:22 GMT

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

Re: Column and Pie Chart

morganaaron — Fri, 09 Jan 2015 15:57:16 GMT

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.

Re: Column and Pie Chart

maxgro — Fri, 09 Jan 2015 19:18:24 GMT

see attachment