topic Re: Trouble with digits/format in QlikView

Trouble with digits/format

Tue, 17 Sep 2013 12:18:06 GMT

The format is showing a column that I don't want and that column appeared after I inserted this code in the pivot table.

=Sum(Bokførtverdi)&' '&(Sum(Bokførtverdi)/sum(Total(Bokførtverdi))*100 &' %')

It would also be nice to limit the number of digits on the percentage to two, is there some kind of round function that is available?

Tue, 17 Sep 2013 12:23:56 GMT

=Sum(Bokførtverdi)&' '&Round(Sum(Bokførtverdi)/sum(Total(Bokførtverdi))*100,0.01) &' %'

This did the trick, however there is perhaps a more elegant way of inserting a line shift...

Tue, 17 Sep 2013 12:54:37 GMT

Another way of achieving this would be to make some changes to the format of the expression in the number tab.

Set the expression to fixed to 2 numbers and use the checkbox show in percent(%).

You can also force the format by changing the code to:

Num(Sum(Bokførtverdi)&' '&(Sum(Bokførtverdi)/sum(Total(Bokførtverdi)), '#.##0,00%')

Carlos_Reyes — Tue, 17 Sep 2013 22:40:12 GMT

Set the expression number format (object properties, number tab) to expression default and use the next:

Num(Sum(Bokførtverdi),'#,##0')

& chr(10) &

Num(Sum(Bokførtverdi)/sum(Total(Bokførtverdi),'#,##0.00%')

Sokkorn — Wed, 18 Sep 2013 03:07:06 GMT

Hi Sverre,

I believe expression below should work in your case

=Sum(Bokførtverdi)&'

'& Num(Sum(Bokførtverdi)/sum(Total Bokførtverdi),'#,##0.00%')

Regards,

Sokkorn

Wed, 18 Sep 2013 08:33:07 GMT

This shows only the absolute nimbers not the percentage

Wed, 18 Sep 2013 10:07:19 GMT

No but

=Sum(Bokførtverdi)&' '&Num(Sum(Bokførtverdi)/sum(Total Bokførtverdi),'#,##%')

Gives me about the same as I already had.

Wed, 18 Sep 2013 12:26:38 GMT

=NUM(Sum(Bokførtverdi),'########### ###')& ' '&Round(Sum(Bokførtverdi)/sum(Total(Bokførtverdi))*100,0.01) &' %'