Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a date field which is month day year. I want to see only those records where this date field is the in Inv Month and Inv Year selected. How would do that?
Let's us say that your field is called DATE.
at the end of the script you can make
Load distinct DATE,
MONTH(DATE) AS InvMonth,
Year(DATE) as InvYear
Resident YourTable
Maybe QlikView didn't recognize your field as a date yet. So, if your field is MMDDYYYY, the script would be:
Load distinct DATE,
LEFT(DATE,2) AS InvMonth,
right(DATE,4) as InvYear
Resident YourTable