topic Qlik Sense - Reuse calculated field in the same load script in App Development

Qlik Sense - Reuse calculated field in the same load script

sth_wch004 — Fri, 29 Dec 2017 02:52:01 GMT

Dear Community,

How to reuse calculated field in the same load script?

[Table]:

LOAD

[Invoice No]

, [Quantity]

, [Price]

, [Quantity] * [Price] AS [Amount]

, [Amount] * {Rate] AS [GST]

FROM [lib://Files/table.xlsx]

(ooxml, embedded labels, table is Sheet1);

In the same load script, same table

[GST] = [Amount] * {Rate] AS [GST]

instead of

[GST] = ( [Quantity] * [Price] ) * {Rate] AS [GST]

Re: Qlik Sense - Reuse calculated field in the same load script

luismadriz — Fri, 29 Dec 2017 04:01:02 GMT

[Table]:

LOAD *,

[Amount] * [Rate] AS [GST];

LOAD

[Invoice No]

, [Quantity]

, [Price]

, [Rate]

, [Quantity] * [Price] AS [Amount]

FROM [lib://Files/table.xlsx]

(ooxml, embedded labels, table is Sheet1);

Cheers

Luis

Re: Qlik Sense - Reuse calculated field in the same load script

sth_wch004 — Fri, 29 Dec 2017 06:10:30 GMT

Thanks Luis,

Actually I have more than hundred of calculated fields

and so on will be like this?

[Table]:

LOAD *

, etc....

LOAD *

, [GST] + [Amount] AS [Gross Amount];

LOAD *

, [Net Amount] * [Rate] AS [GST];

LOAD [Invoice No]

,[Quantity]

,[Price]

,[Rate]

,[Quantity] * [Price] AS [Net Amount]

FROM [lib://Desktop/table.xls]

(biff, embedded labels, table is Sheet1$);