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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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..