topic Re: SQL select where clause in QlikView

SQL select where clause

sivavasam — Sat, 13 May 2023 11:58:49 GMT

While implementing incremental load source from Oracle database.

vMaxDate = Peek ('Maxdate ',0) and also tried ('MaxDate', 0,'Table name '

Table:

Load

Status_Date,

AAAA,

BBBB,

CCCC;

SELECT

Status_Date,

AAAA,

BBBB,

CCCC

FROM Table

Where Status _Date >'20230131' ; and tried ( where Status_Date > '$(vMaxDate)' but no use...I need this date format 20230131 as variable which responds to select statement.

Instead of Date I need to store Max date from QVD which is stored in variable . But it's not working.

Re: SQL select where clause

rubenmarin — Sat, 13 May 2023 14:58:06 GMT

Hi, you can give that format to the vMaxDate variable using the Date() function:

vMaxDate = Date(Peek ('MaxDate',0),'YYYYMMDD')

You also need to confirm that the max date has been loaded on the table where MaxDate field is loaded.

Re: SQL select where clause

sivavasam — Sat, 13 May 2023 15:36:20 GMT

Thank you so much I got it ....