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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
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