Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
maybe like this ? :
If(Status = 'In Service',
If(today() - [Last Connected] > 3,
today() - [Last Connected], 0), 0)
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.
🙂
maybe like this ? :
If(Status = 'In Service',
If(today() - [Last Connected] > 3,
today() - [Last Connected], 0), 0)