topic toggle values in a pie-chart in QlikView

toggle values in a pie-chart

ali_hijazi — Mon, 23 May 2011 12:52:44 GMT

hello I have a pie chart

in the expressions tab I have put the sum(field)

is there a way to toggle the checkbox (Relative) from a button on the sheet?

toggle values in a pie-chart

yasus — Mon, 23 May 2011 13:36:01 GMT

There is not such a button but you could't create one by making use of a macro. The easiest way is to create 2 pie charts. One with absolute and a second with relative values.

toggle values in a pie-chart

erichshiino — Mon, 23 May 2011 13:49:18 GMT

Hi,

I use it in a different way with the same result.

Create a second and identical expression

sum(field) and check the relative box.

Then, you group those expressions (with the Group Button below the expressions box).

This will include a cycle expressions button, and the user can click it to change visualization

Hope it helps,

Erich