New Field created but not populating with value

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello:

I am very new to Qlik and data visualization is not my background but I am trying to learn more.

I have a field called ArrivalDateTime which is in the format mm/dd/yyyy hh:mm:ss.

I want to create a new Field, YesterdayArrivalDateTime, which only populates a value if the ArrivalDateTime has a date of yesterday.

The app and its data are on a daily refresh.

I tried putting the following in the Data Load Editor:

If(floor(ArrivalDateTime=Today()-1), ArrivalDateTime) as [YesterdayArrivalDateTime];

The code loads, and there is a new field called YesterdayArrivalDateTime, but all of it is null, even for data where the arrival date was yesterday.

I have a feeling I am missing something in the line of code but am not sure, could you give any pointers?

Thanks in advance!

Re: New Field created but not populating with value

m_woolf — Tue, 24 Apr 2018 16:10:42 GMT

You might try:

If(floor(ArrivalDateTime)=Today()-1, ArrivalDateTime) as [YesterdayArrivalDateTime];

If that doesn't work, you might use num((floor(ArrivalDateTime))

Anonymous — Tue, 24 Apr 2018 16:23:38 GMT

Thank you! The first option worked!