topic Re: Import Excel formulas in QV in QlikView

Import Excel formulas in QV

Fri, 06 Feb 2015 08:01:37 GMT

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.

Re: Import Excel formulas in QV

prieper — Fri, 06 Feb 2015 09:11:38 GMT

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

Re: Import Excel formulas in QV

Fri, 06 Feb 2015 10:34:19 GMT

The formula en Excel is calculated, but I want to get the formula, not the result...

Re: Import Excel formulas in QV

Anonymous — Fri, 06 Feb 2015 11:16:20 GMT

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.

Re: Import Excel formulas in QV

PrashantSangle — Fri, 06 Feb 2015 11:18:11 GMT

Hi,

This is not possible.

In Qlikview you have to write expression for this.

Regards

Re: Import Excel formulas in QV

prieper — Fri, 06 Feb 2015 11:25:48 GMT

Would like to see the Excel - or a sniplet of it,

can you please post?

Peter

Re: Import Excel formulas in QV

Fri, 06 Feb 2015 12:15:38 GMT

The best solution I've found is add a column using =FORMULATEXT(A1) and using this column in QV.

Thanks at all.