topic Re: Conditional field according to a value in QlikView

Conditional field according to a value

CamilleA — Tue, 30 Nov 2021 17:10:12 GMT

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 !!! 🙂

Re: Conditional field according to a value

Or — Tue, 30 Nov 2021 18:06:36 GMT

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/InterRecordFunctions/below.htm