Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi community,
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
Load
Opendate
Feom xls file
Where Opendate>=Date#('01-Jan-20','DD-MMM-YY')
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)
LOAD *
WHERE MonthName(Opendate)= MonthName(makedate(2020,1))
Hi Vegar,
Thanks but 0 lines fetched on reloading.
In my excel the date is in cuatom format dd-mmm-yy.
I have script
Load
*Resident Data
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.😟
Hi @Vegar
not getting the output. 0 lines fetched. Column in excel in which dates mentioned is in custom format DD-MMM-YY.
Please help😟
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.