topic Re: Year Expression Returning Null in QlikView

Year Expression Returning Null

notlohdahc — Fri, 10 Jan 2025 18:08:26 GMT

I'm in QlikView not QlikSense if that makes a difference . .

This statement is working for all dates prior to 01/01/2025, but all dates in 2025 are returning a null value. Why?

Year(YearStart(OpenOrdDateSchedShip)) as [OpenOrd Date Sched Ship Year]

Re: Year Expression Returning Null

eddyvargas — Fri, 10 Jan 2025 18:59:26 GMT

Check if your script has:

SET DateFormat='MM/DD/YYYY';

Is not necessary YearStart, only Year(OpenOrdDateSchedShip)

Re: Year Expression Returning Null

Vegar — Sat, 11 Jan 2025 18:09:09 GMT

Both Year(YearStart(OpenOrdDateSchedShip)) and the suggested Year(OpenOrdDateSchedShip) should work.

I'm guessing here, but could it be that you don't have the dates for 2025 in the table where you are defining [OpenOrd Date Sched Ship Year]? And the values with null are actually missing.

This is only a valid guess if OpenOrdDateSchedShip i a key field between that table and another table that do contain 2025 date values.

Re: Year Expression Returning Null

Or — Sun, 12 Jan 2025 08:23:19 GMT

When date and time fields stop working, the first thing to do is confirm that the field is actually being treated as a date. You can confirm this by using Num(FieldName) to see if you get a numeric result matching the date.

Re: Year Expression Returning Null

Bhushan_Mahajan — Mon, 13 Jan 2025 05:37:16 GMT

@notlohdahc Please check the format of Date in Qlik as well as your source.

Re: Year Expression Returning Null

notlohdahc — Mon, 13 Jan 2025 13:42:43 GMT

I found the problem. It was further upstream in the script. it's hard to explain . . . We have a variable that is supposed to hold the current date. For some reason that date was getting set to 03/10/2025 and not 01/10/2025. This caused schedship dates in 2025 and beyond to not be considered valid dates. After fixing this variable, dates are being recognized as valid

I personally do not understand why this variable caused the SchedShip dates to come up as null. But fixing it fixed my issue.