Conditional field according to a value

[CamilleA]

Hello !

I want to create a conditional column according to this rules :

-if Gap_€ = 0 : action = "Nothing to report"

-if Gap_€ <>0 : action = "Reminder to do"

BUT if we have the same amount (+/-) for the same invoice date the action is "Credit note" (this one makes me crazy !!)

Here is the example of my tab I want :

Do you think it is possible ? Thank you !!! 🙂

[Or · Accepted solution]

Based solely on the information in this table, it doesn't seem directly possible - there's no way to know that invoices 156 and 157 are related, and likewise for 596 and 597. However, you could check the values using below() and above() to see if they offset. This will only work if credit notes are guaranteed to be directly above/below each other, though, as there doesn't seem to be any other way of matching them.

https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/ChartFunctions/InterRecor...