topic use Macro to change Number Format Setting in QlikView

use Macro to change Number Format Setting

Tue, 01 Feb 2011 09:21:09 GMT

Dears,

I have a chart with Expressions that need show different data format depends on selection:

eg:

if '%' is selected, the number format in chart should show %. (In properties, there is tab called Number Format Setting, the 'Show %' should be tick in that case).

But if 'Actual Number' is selected, % would be disappear in chart (the 'Show %' box shouldn't be unticked).

Does anyone know how to use macro to control it?

Thanks a lot [8-|]

use Macro to change Number Format Setting

Anonymous — Tue, 01 Feb 2011 20:57:00 GMT

There is no need for macro. A "normal" way is to create two expressions, one for % and another for actual number, and group them in cycle. Define format for each in "number" tab.
One expression with different formats is possible as well, and also without macro. Define data format conditionally directly in expression, for example:
num(<your expression>, if(Var='%', '#,##0.00%', '###,###'))
And, use "Expression default" on number tab.

Re: use Macro to change Number Format Setting

Thu, 11 Sep 2014 12:56:50 GMT

In case anyone does need to do this via a macro for other reasons, try this thread:

Dynamic Chart Macro and Number Format Problem

Re: use Macro to change Number Format Setting

Thu, 11 Sep 2014 12:57:53 GMT

And this one:

Dynamic Chart - Expression, Number Format Problem