Solved: Create a new % Column in a Table - Qlik Community

hkg_qlik · ‎2010-12-03

Hi everyone,

I have a really simple question.

DIVISION	Balance	Past Due	% Balance	% Past Due
A	$1,111,122.00	$117,000.00	27.45%	2.26%
B	$200,000.00	$330,003.00	4.94%	6.38%
C	$115,000.00	$487,737.00	2.84%	9.43%
D	$400,000.00	$366,365.00	9.88%	7.08%
E	$2,222,222.00	$3,873,773.00	54.89%	74.86%
Total	$4,048,344.00	$5,174,878.00	100.00%	100.00%

The above Table has been created in Excel.

I have the Column name DIVISION, BALANCE and PAST DUE in Qlikview.

Now I want to add % Balance and % Past Due in the same table in Qlik as shown above.

NOTE: In excel its very easy to create a new column and add some formula to create relative percent as shown above.

Can anyone guide me to create the same in Qlikview?

Thanks,

H

Report Inappropriate Content · ‎2010-12-03

You might be using the Table Box object which does not allow you to create expressions.

Use the Chart > Straight Table object instead.

Use the Division, Balance, past due as dimensions... then create expression for %Balance and %Past Due

View solution in original post

Report Inappropriate Content · ‎2010-12-03

You might be using the Table Box object which does not allow you to create expressions.

Use the Chart > Straight Table object instead.

Use the Division, Balance, past due as dimensions... then create expression for %Balance and %Past Due

Report Inappropriate Content · ‎2010-12-03

it looks like your expressions would be

%Balance = sum(Balance)/sum(TOTAL Balance)

%Past Due = sum([Past Due])/sum(TOTAL [Past Due])

In the Number tab, you might want to change it to a double fixed to 2 decimal places and represent it as a percentage.

hkg_qlik · ‎2010-12-03

Thanks Paulo for the Reply !

It worked for me.

Regards,

H

Report Inappropriate Content · ‎2010-12-20

<body>I have the same problem but the formula is not working. my data is the result of a calculation: FORMULA: -----Sum (if (InYear ([Data Documento], Today(), -1), Quantità *[Peso Netto Anagrafico]))/100----- I want to show these data as a % ot the total "sum(Quantità *[Peso Netto Anagrafico])/100" taken from invoices where where Year ([Data Documento]=Year(Today(), -1) pls help! Francesca ex.: <col width="89"></col> <col span="2" width="72"></col> <tr> <td width="89" height="18"> </td> </tr> <tr> <td width="89" height="18">Codice Articolo</td> <td width="72">FORMULA </td> <td width="72">Peso</td> </tr> <tr> <td height="18">ip code 1</td> <td></td> <td align="right">0,00%</td> </tr> <tr> <td height="18">ip code 2</td> <td align="right"> 100</td> <td align="right"> 5,88%</td> </tr> <tr> <td height="18">ip code 3</td> <td align="right"> 300</td> <td align="right"> 17,65%</td> </tr> <tr> <td height="18">ip code 4 </td> <td align="right">500 </td> <td align="right">29,41%</td> </tr> <tr> <td height="18">ip code 5</td> <td align="right"> 800 </td> <td align="right">47,06%</td> </tr> <tr> <td height="18">total</td> <td align="right"> 1700</td> <td align="right"> 100,00%</td> </tr> <td width="72"> </td> <td width="72"> </td> </body>