Creating calculated field from 2 dates with condition of specific status

[Thabang231]

Hi Guys

May i please get an assistance here, I need to calculate a new field on Data Manager to have OD4D (Overdue for Download) column, and i need to do this by saying if status field is not "Out of Service" then give me difference between LastConnectedDate field from Today's date. I wanna see the difference in days.

Attached is the logic but in PowerBI

Your support is highly appreciated. Thanks in Advance.

Regards

T

[QFabian]

Hi @Thabang231 , i think is very similar to your power BI expression :

[Thabang231]

Hi @QFabian 

Thanks once again but at moment the values that are returning are not correct , please look at the snip below , "Out of Service -Attached" status should always remain Zero because the goods are not in used, and only do count of "In Service" as to see how many days difference from last Connected to today(). 

Hope to hearing from You, I am amazed with the Qlik community support.

🙂

[QFabian · Accepted solution]

maybe like this ? : 

If(Status = 'In Service',

If(today() - [Last Connected] > 3,
today() - [Last Connected], 0), 0)