Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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;