Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
tenyeapen
Contributor
Contributor

From Command in qlikview

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?

1 Reply
wade12
Partner - Creator II
Partner - Creator II

TableName:

LOAD

Field1,

Field2,

...

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

...

FROM DataSource;