topic Dynamic month change using field selection in load script in QlikView

Dynamic month change using field selection in load script

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

Please help me to dynamic change of where clause Sales Date

//Script

T1:

LOAD OrgID,

Sales_Date

FROM

Inventry.xlsx

(ooxml, embedded labels, table is Sheet2)

Where Sales_Date>='11/01/2017' and Sales_Date<='11/30/2017';

NoConcatenate

T2:

LOAD OrgID,

Sales_Date

FROM

Inventry.xlsx

(ooxml, embedded labels, table is Sheet2)

Where Sales_Date>='11/01/2012' and Sales_Date<='10/31/2017';

//Script end

Create variable for Sales Date to change based on selected 'monthname' Filed

T1 - selected month

(Ex: select Dec 2017 = Sales_Date>='12/01/2017' and Sales_Date<='12/31/2017'

select Nov 2017 = Sales_Date>='11/01/2017' and Sales_Date<='11/30/2017')

T2 - Last Five years

(Ex: select Dec 2017 = Sales_Date>='12/01/2012' and Sales_Date<='11/30/2017'

select Nov 2017 = Sales_Date>='11/01/2012' and Sales_Date<='10/31/2017')