topic Re: setup dynamic date in where clause current month in QlikView

setup dynamic date in where clause current month

karan_kn — Wed, 25 Nov 2020 16:16:04 GMT

Please help me to setup date dynamic instead of hardcoding in where clause current month, so that it will update with current month in incremental load

T1:

LOAD CustID,

Sales_Date

FROM

Inventry.xlsx (ooxml, embedded labels, table is Sheet2)

Where Sales_Date>='12/01/2018' and Sales_Date<='12/31/2018';

Store QVD

Re: setup dynamic date in where clause current month

sunny_talwar — Fri, 19 Jan 2018 12:51:22 GMT

May be this

Where Sales_Date>=MonthStart(Today()) and Sales_Date<=MonthEnd(Today());

Re: setup dynamic date in where clause current month

karan_kn — Fri, 19 Jan 2018 12:57:29 GMT

Thanks Sunny stalwar1 , Can you help me to setup where clause for this as well:

Last two years :

Where Sales_Date>='01/01/2015' and Sales_Date<='12/31/2017'

Re: setup dynamic date in where clause current month

sunny_talwar — Fri, 19 Jan 2018 13:00:52 GMT

May be this

Where Sales_Date>=YearStart(Today(), -3) and Sales_Date<YearStart(Today());

Note that instead of doing <= 12/31/2017, I did < 01/01/2018

Re: setup dynamic date in where clause current month

karan_kn — Fri, 19 Jan 2018 13:02:10 GMT

Thanks Sunny