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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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

Labels (1)
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..