topic Re: From Command in qlikview in QlikView

From Command in qlikview

tenyeapen — Wed, 25 Nov 2020 16:16:04 GMT

i have a data named InvoiceTAT loaded from the database. I need to call this in a if condition in script area. can some one please suggest how the From statement should be?

Re: From Command in qlikview

wade12 — Mon, 04 Nov 2019 16:08:47 GMT

TableName:

LOAD

Field1,

Field2,

...

If(Currency='Euro', SaleAmount*ExchangeRate, SaleAmount) as SaleAmount,

...

FROM DataSource;