Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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..