Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
karan_kn
Creator II
Creator II

Dynamic month change using field selection in load script

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')

0 Replies