Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I want to load a excel sheet in QV, but the formulas as =A1+B1+C1 appears like a number '0'. This is my script:
Directory;
LOAD RowNo() AS Fila,
[Nº CUENTA],
CUENTA,
Resultado
FROM
PlantillaCuentasAnuales.xlsx
(ooxml, embedded labels, table is PD);
The 'Resultado' column has formulas, I want to have these in text. Can I get this?
Thanks.
Guess that the "Resultado" is formatted as text, thus the formula is not calculated in Excel, but shown as formula.
You may load as TEXT(Resultado).
HTH Peter
The formula en Excel is calculated, but I want to get the formula, not the result...
I don't think it is possible... QlikView will get only the result of your formula as Excel calculate the formula on that field.
You should create a new column in your Excel file where you copy-paste your formula without the first sign "=" then it will be a text for Excel and QlikView will get it as a text.
Hi,
This is not possible.
In Qlikview you have to write expression for this.
Regards
Would like to see the Excel - or a sniplet of it,
can you please post?
Peter
The best solution I've found is add a column using =FORMULATEXT(A1) and using this column in QV.
Thanks at all.