topic Re: QlikView Resident Load in SQL where clause in App Development

QlikView Resident Load in SQL where clause

devarshigoswami — Wed, 29 Jun 2022 18:41:30 GMT

Thanks for taking the time to read this....
Can I add a resident load in SQL FROM clause?

Like so ...

TMP:
SQL SELECT * from table WHERE date_parse(date,'%Y-%m-%d') < date_trunc('month', current_date)
and
date_parse(date,'%Y-%m-%d') >= date_trunc('month', current_date) - interval '1' month

;

Main:

SQL SELECT item, max(date)
FROM Resident TMP
GROUP BY 1;

Re: QlikView Resident Load in SQL where clause

MartW — Wed, 29 Jun 2022 19:28:32 GMT

I'm more of a Qlik Sense Guy, but I think this is not possible in neither of the Qlik products (Qlikview and or Qlik Sense)

what you could do is load the TMP table into qlik first. after that do something like Main: noconcatenate Load * resident TMP Group BY 1; and drop the TMP table with drop table TMP;

Re: QlikView Resident Load in SQL where clause

sidhiq91 — Thu, 30 Jun 2022 03:20:20 GMT

@devarshigoswami Whenever you type SQL in Script Editor, Qlik will hit the SQL server to fetch the data from there.

In your Example, you don't have to mention SQL again before the load for the 'Main' table since that data is already fetched. All that you need to do is:

Noconcatenate

Main:

Load * Resident TMP group b column_name;

Re: QlikView Resident Load in SQL where clause

vinieme12 — Fri, 01 Jul 2022 06:29:51 GMT

If you want to process the result of another SQL, Just use a nested query!!

Main: SQL SELECT A.item, max(A.date) FROM (SELECT * from table WHERE date_parse(date,'%Y-%m-%d') < date_trunc('month', current_date) and date_parse(date,'%Y-%m-%d') >= date_trunc('month', current_date) - interval '1' month ) A Group by A.item ;