Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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.
Thanks Paulo for the Reply !
It worked for me.
Regards,
H
<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à *[Peso Netto Anagrafico]))/100-----</p> <p>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)</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>