This content has been marked as final. Show 3 replies
I'm very new at using Qlikview for our medical office to analyze medical data. I am able to pull in dates from our sql database however, I am not sure how to condense the year to only pull records > 1/1/2014. Right now the data goes as far back as 1995 and is to much info to load.
Here are the table I'm using..
Year (OBSDATE) as OBSYear,
Month (OBSDATE) as OBSMonth,
Weekday (OBSDATE) as OBSWeekDay,
Day (OBSDATE) as OBSDay,
Hour (OBSDATE) as OBSHour,
SQL SELECT HDID,
What is the best way to write this statement?