topic Re: Can number formats be changed dynamically? in QlikView

Can number formats be changed dynamically?

ljdlumley — Fri, 16 Nov 2012 10:50:18 GMT

I have a table giving results for a few years, averages, max values etc for data that changes depending on which Key Performance Indicator is selected from an inline table.

For some KPIs it makes no sense to see any decimal places (Total spend in £) and others I want to see down to 2 decimal places as the figures are small numbers 0.13, 0.16 etc that need displaying.

Is it possible to do what I'm after?

thanks

John

Re: Can number formats be changed dynamically?

Fri, 16 Nov 2012 11:00:11 GMT

in number tab

select fixed to -2 decimal places

then it give upto 2 decimal places only

Re: Can number formats be changed dynamically?

jagan — Fri, 16 Nov 2012 11:01:51 GMT

Hi,

PFA file, hope it helps you.

Try this expression

=If(Profit% < 1, Profit%, Num(Profit%, '###,#0'))

and in Number tab set Number format settings to Expression Default

Regards,

Jagan.

Re: Can number formats be changed dynamically?

ljdlumley — Fri, 16 Nov 2012 11:04:33 GMT

Hi, that is ok for a normal table but my table will show different data depending upon other selections.

If Measure 1 is selected in another list I want the table to be 0 decimal places. If Measure 2 or 3 is selected then I want the table to be 2 decimal places, Measure 4 1dp and so on.

Re: Can number formats be changed dynamically?

ljdlumley — Fri, 16 Nov 2012 11:11:03 GMT

Perfect. Thank you.