Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

wayd of loading data into qlikview using select

can anyone expain me what the below statement do?

SQL select * from getpilotfleetrecency('$(datFrom)', '$(datTo)');

getpilotfleetrecency is neither a table nor qvd.. so please let me know from what other sources we can load data

3 Replies
Not applicable
Author

looks like a sql function

Not applicable
Author

yes.. it may be.. can we get data from sql using functions and load it into qlikview.. something like

load

column1,

column2

;

select * from sqlfunction(parameters);

Not applicable
Author

Using SQL function and load it into qlikview

getpilotfleetrecency is ur source table Name...

('$(datFrom)', '$(datTo)') are two variable.. // Duration of data in ur table..