topic Re: Format expression in a label in QlikView

Format expression in a label

peterderrington — Thu, 28 May 2020 09:19:36 GMT

Hi,

Not sure if this can be done but i'm using the following expression as a label so that users can quickly see the numeric value in a graph but i want to limit the formatting to only 2 decimal places.

So the label expression is: =Concat('Mean Average Length of stay' & ' - ' & Avg(TOTAL Aggr(Avg([Length of Stay - Days]),[Admission Month/Year])))

Whilst the expression its displaying is Avg(TOTAL Aggr(Avg([Length of Stay - Days]),[Admission Month/Year]))

and i get this image:

Now thats lovely but as i say i'd like to limit that output to just 2 decimal places so that it shows as 12.42

Can it be done?

Re: Format expression in a label

zhadrakas — Thu, 28 May 2020 09:24:25 GMT

you can try to wrap num() like this

=num(Avg(TOTAL Aggr(Avg([Length of Stay - Days]),[Admission Month/Year])), '0,00')

Re: Format expression in a label

peterderrington — Thu, 28 May 2020 10:25:25 GMT

No, i'm missing something, when i try the whole expression in the label field :

=Concat('Mean Average Length of stay' & ' - ' & =Num(Avg(TOTAL Aggr(Avg([Length of Stay - Days]),[Admission Month/Year])),'0,0,0'))

I just get 'Error in expression'

Probably just missing a simple piece of syntax but i cant see it this morning

Re: Format expression in a label

zhadrakas — Thu, 28 May 2020 10:30:31 GMT

try these

=Concat('Mean Average Length of stay' & ' - ' & Num(Avg(TOTAL Aggr(Avg([Length of Stay - Days]),[Admission Month/Year])),'0,00')) =Concat('Mean Average Length of stay' & ' - ' & Num(Avg(TOTAL Aggr(Avg([Length of Stay - Days]),[Admission Month/Year])),'0.00'))

Re: Format expression in a label

peterderrington — Thu, 28 May 2020 10:34:40 GMT

It was the second one.

Thank you so much, very appreciated.