Translate SQL Query to be replicated on QVDS in Qlik Cloud Application

Marcushenriquesk — Tue, 24 May 2022 16:57:30 GMT

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.

topic Translate SQL Query to be replicated on QVDS in Qlik Cloud Application in App Development

Translate SQL Query to be replicated on QVDS in Qlik Cloud Application