Discussion board where members can get started with QlikView.
Please help me in getting the output of a particular month from an excel file having data from 2001-2020.
I want to extract only Jan 2020 data from the file.
Below is the script have written
Feom xls file
This is not giving me only jan 20 month data.
Your script is loading all data larger than January 1 2020.
You can do like this to set an upper and lower limit. (Assuming that Opendate is a date field in excel)
WHERE MonthName(Opendate)= MonthName(makedate(2020,1))
Thanks but 0 lines fetched on reloading.
In my excel the date is in cuatom format dd-mmm-yy.
I have script
Where ( in condition on getting only jan month 20 data).
On applying where condition mentioned by you 0 lines fetched. I am sorry but new to qlikview.😟
not getting the output. 0 lines fetched. Column in excel in which dates mentioned is in custom format DD-MMM-YY.
Could you post a sample excel and QV-docukent? It does not need to be the same data, but it needs a sample where the date fileter issue can be tested.