topic Re: Multiple number formats in a dynamic chart in QlikView

Multiple number formats in a dynamic chart

Anonymous — Sun, 29 Mar 2015 20:34:36 GMT

Is it possible to have a dynamic chart with a bar and pie chart but have a different number format for each?

e.g. Bar chart = Number

Pie Chart = Percentage

Re: Multiple number formats in a dynamic chart

sunny_talwar — Sun, 29 Mar 2015 22:01:18 GMT

I guess one way to do this would to have two charts, both on top of each other and conditionally hide and show the charts.

Best,

Sunny

Re: Multiple number formats in a dynamic chart

Sun, 29 Mar 2015 23:11:40 GMT

Or a container with copies of the chart as bar&pie with different number formats.

Re: Multiple number formats in a dynamic chart

marcus_sommer — Mon, 30 Mar 2015 12:10:54 GMT

It's only with macros possible tor query and react on the objecttyp and this isn't really recommended: Macros are Bad. Therefore it's better to use two objects like above mentioned.

- Marcus

Re: Multiple number formats in a dynamic chart

avinashelite — Mon, 30 Mar 2015 12:14:09 GMT

As per my knowledge their is no direct method to do this, macro would be possible with some limits.

If its not a quick change option in the chart try with hide and show logic that would help you

Re: Multiple number formats in a dynamic chart

Anonymous — Mon, 30 Mar 2015 14:57:53 GMT

Thanks all. I've gone with the container method as this gives me exactly what I want.