As long as I've understod, you have only one dimension, nine rows are coming from a database and the last row comes from another source.
I would create a table in the data model with 9 rows coming from a database and I would ad a new row to the table.
I've writed an small example:
0- The data:
I've write an excel file with 2 columns 'dimension' and 'value'. The excel has 9 rows.
1- The script.
1.1- Load nine rows from an excel file.
(ooxml, embedded labels, table is Sheet1);
1.2- Add an additional row.
LOAD * INLINE [
The 2 tables has exactly the same fields and QlikView will create only one table with 10 rows.
2- Visualization, the table.
Now you have a table with 9 rows coming from an excel file and a row loaded inline. To finish this eample you need an expresion for the first 9 row and a diferent expresion for the last row.
I used this expression.
if(RowNo()<=9 and RowNo()>=1, sum(value), value*34)
Now I've a table (graph) with 2 columns and 10 rows. In the dimension 9 rows comes from the excel and the last one is generated in the script. In the values you have an expression for the 9 rows comming from the excel and a different expression for the last one.