topic Re: Straight Table Multiple number formats in QlikView

Straight Table Multiple number formats

vardhancse — Wed, 23 Dec 2015 13:16:08 GMT

Hi,

Have one requirement is that, one staright table dimension value should have multiple number formats.

For eg:

#,###.0

#0.00%

Can please do the needfull.

Re: Straight Table Multiple number formats

sasikanth — Wed, 23 Dec 2015 13:19:03 GMT

HI,

based on any conditions ? if so please specify

Re: Straight Table Multiple number formats

swuehl — Wed, 23 Dec 2015 13:19:47 GMT

You can check the dimension value and apply different formats using num() function in the expression, keep the number format on number tab to 'expression default':

=Num(

Sum( Amount),

Pick(Match( YourDimension, 'A', 'B'), '#,###.0','#0.00%')

)

Re: Straight Table Multiple number formats

vardhancse — Wed, 23 Dec 2015 13:22:07 GMT

Hi,

No conditions, some thing similar to below table:

Dim	Actual	Plan
Dim1	10.3	10.42
Dim2	20%	30%

now for Dim1 the format is

#,###.0

and for dim2 the format is

#0.00%

Re: Straight Table Multiple number formats

sasikanth — Wed, 23 Dec 2015 13:30:58 GMT

HI,

Try like

If(Dim='Dim1',num(Sum(Actual),'#,##0.0'),num(Sum(Actual),'#,##0%'))

i dont think it will work if we have many values

Please share your sample file

Re: Straight Table Multiple number formats

vardhancse — Wed, 23 Dec 2015 13:42:48 GMT

Hi,

Thanks for your reply,

By using above condition only 1 dimension number format was changing not all.

can please let me know that I am doing right.?

Re: Straight Table Multiple number formats

swuehl — Wed, 23 Dec 2015 13:44:34 GMT

Could you upload a small sample QVW?

Re: Straight Table Multiple number formats

sunny_talwar — Wed, 23 Dec 2015 13:50:37 GMT

Using Stefan's technique:

Expression: =Num(Sum(Actual), Pick(Match(Dim, 'Dim1', 'Dim2'), '#,##0.0', '##%'))

=Num(Sum(Plan), Pick(Match(Dim, 'Dim1', 'Dim2'), '#,##0.0', '##%'))