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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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?

Labels (1)
1 Reply
wade12
Partner - Creator II
Partner - Creator II

TableName:

LOAD

Field1,

Field2,

...

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

...

FROM DataSource;