topic Re: Displaying % in a table in QlikView

Displaying % in a table

Tue, 02 Dec 2014 17:35:37 GMT

Hi - I am trying to display revenue as a % of total but for some reason the % option is not working for me. This issue seem to only exist in the second column, % Last 3 Month.

Here is the formula that i am using to calculate % last 3 month:

=SUM({<month_offset={[>=-1<0]}>}price)+SUM({<month_offset={[>=-2<0]}>}price)+SUM({<month_offset={[>=-3<0]}>}price)/1000

Please help!

Re: Displaying % in a table

Gysbert_Wassenaar — Wed, 03 Dec 2014 12:53:54 GMT

Try the option Fixed to with two decimals

Re: Displaying % in a table

saurabh5 — Wed, 03 Dec 2014 14:28:49 GMT

what if you check mark for showing 'relative' value in the expression.

Re: Displaying % in a table

Wed, 03 Dec 2014 14:42:19 GMT

go for relative option in chart level

Re: Displaying % in a table

MarcoWedel — Wed, 03 Dec 2014 16:23:05 GMT

Hi,

maybe this solution works for you:

LOAD *,
    Num(Number, '(DEC)') as NumberDec,
    Dual(Num(Number*100,'(DEC)')&' %',Number)as NumberDec%;
LOAD pow(10, (Rand()*20)-10) as Number
AutoGenerate 40;

hope this helps

regards

Marco

Re: Displaying % in a table

Anonymous — Thu, 04 Dec 2014 14:49:54 GMT

use this

Num(Sum(sales_QTY),'###,##0.00%')