QlikView App Dev

[danialier]

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

[Gysbert_Wassenaar · Accepted solution]

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

[morganaaron]

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]

see attachment