Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to put filter on date in script.
Have written the below code
Load
Open_date,
From (xls file)
Where
Open_date>='01-Jan-20';
But i am not getting the correct output. I am new to qlikview and please help me on this.
Try this:
LOAD
Open_date
FROM (xls file)
WHERE
Open_date >= Date#('01-Jan-20', 'DD-MMM-YY');
Little confused on things being marked solved when the post is asking for further assistance, so dropping a couple other links that may be of help:
https://community.qlik.com/t5/Qlik-Design-Blog/Why-don-t-my-dates-work/ba-p/1465849
https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157
I am going to change the marked solution to Vegar's post as my hunch is you figured out what you had done incorrectly based upon his post and did not take the time to write-up exactly what was wrong.
Regards,
Brett
Try this:
LOAD
Open_date
FROM (xls file)
WHERE
Open_date >= Date#('01-Jan-20', 'DD-MMM-YY');
Hi,
Thanks for support
I have data from 2001 to Jan 2020 and only want Jan 2020 to generate output file.
However, while running below code giving me all the rows from 2001.
Hi,
Please help urgently...
I have data from 2001 to 2020in xls file.
And want to generate output file containing only Jan 2020 data filter using qlikview.
Load
Open_Date
From (xls) file
Where
Open_date>=Date#('01-Jan-20','DD-MMM-YY);
Not giving me correct output of containing only jan month data. Its giving me full report seems filter is not getting captured.
Little confused on things being marked solved when the post is asking for further assistance, so dropping a couple other links that may be of help:
https://community.qlik.com/t5/Qlik-Design-Blog/Why-don-t-my-dates-work/ba-p/1465849
https://community.qlik.com/t5/Qlik-Design-Blog/The-Date-Function/ba-p/1463157
I am going to change the marked solution to Vegar's post as my hunch is you figured out what you had done incorrectly based upon his post and did not take the time to write-up exactly what was wrong.
Regards,
Brett