Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Displaying % in a table

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

12-2-2014 12-31-15 PM.png

12-2-2014 12-31-58 PM.png

Please help!

Z

Tags (1)
5 Replies

Re: Displaying % in a table

Try the option Fixed to with two decimals  


talk is cheap, supply exceeds demand
saurabh5
Contributor II

Re: Displaying % in a table

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

Not applicable

Re: Displaying % in a table

go for relative option in chart level

Re: Displaying % in a table

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;

QlikCommunity_Message_144348_Pic1.JPG.jpg

hope this helps

regards

Marco

asimansari2017
New Contributor III

Re: Displaying % in a table

use this

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

Community Browser