Translate SQL Query to be replicated on QVDS in Qlik Cloud Application
I originally created a query that is getting data through a NAT connection with an internal data base source. However, we made a move to use the Qlik Data Transfer Tool to load data into our qlik cloud environment instead. Using the Qlik Data Transfer Tool I have imported all the tables that are need to replicate the original query that created the data view. Here is the query, however, I am unsure how to translate it into a format that uses the QVDs within the environment.
MinReceivedLocTable: sql select LOCATIONS.LOC_ID ,TO_char(min(trunc(REQUISITIONS.RECEIVED_DATE)), 'MM/dd/yyyy') as RECEIVED_DATE_MIN FROM ACUTIS.REQUISITIONS INNER JOIN ACUTIS.REQ_PANELS ON REQUISITIONS.ACC_ID = REQ_PANELS.ACC_ID INNER JOIN ACUTIS.LOCATIONS ON REQUISITIONS.LOC_ID = LOCATIONS.LOC_ID where trunc(REQUISITIONS.RECEIVED_DATE) is not null and REQUISITIONS.Del_flag = 'F' group by LOCATIONS.LOC_ID;
I have the Requisitions and locations tables within the same space as the application in QVD format. How do I go about replicated this SQL query to return the same data table from the QVDs.