Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
hkg_qlik
Creator III
Creator III

Create a new % Column in a Table

Hi everyone,

I have a really simple question.

DIVISIONBalancePast Due% Balance% Past Due
A$1,111,122.00$117,000.0027.45%2.26%
B$200,000.00$330,003.004.94%6.38%
C$115,000.00$487,737.002.84%9.43%
D$400,000.00$366,365.009.88%7.08%
E$2,222,222.00$3,873,773.0054.89%74.86%
Total$4,048,344.00$5,174,878.00100.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

1 Solution

Accepted Solutions
Not applicable

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

4 Replies
Not applicable

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

Not applicable

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
Creator III
Creator III
Author

Thanks Paulo for the Reply !

It worked for me.

Regards,

H

Not applicable

<body><p>I have the same problem but the formula is not working. </p> <p>my data is the result of a calculation:</p> <p>FORMULA: -----Sum (if (InYear ([Data Documento], Today(), -1), Quantit&agrave; *[Peso Netto Anagrafico]))/100-----</p> <p>I want to show these data as a % ot the total &quot;sum(Quantit&agrave; *[Peso Netto Anagrafico])/100&quot; taken from invoices where where Year ([Data Documento]=Year(Today(), -1)</p> <p>pls help!</p> <p> </p> <p>Francesca</p> <p> </p> <p>ex.:</p> <p> </p> <p> </p> <p> </p> <p> </p> <p><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> </p> <p> </p> <p> </p> <td width="72"><br /></td> <td width="72"><br /></td> <p> </p></body>