Why is the Critical Task column showing blank values in Qlik Sense?

[rajany089]

Hi Qlik Community,

I am encountering an issue while implementing logic to determine if a task is critical based on the "Task Short Description" in Qlik Sense. I have a dataset where the "Critical_Task_Final" column is derived based on the "Task Short Description." As shown in the screenshot, I expect the logic to return either "Yes" or "No," and it works correctly for one of the rows, which shows "No." However, for the second occurrence of the same task (same "Task Number" and "Request Number"), the "Critical_Task_Final" column is blank.

Here is what I am trying to understand:

1. Why does the "Critical_Task_Final" column return a blank value for the second row?
2. Could it be due to data duplication, or is it an issue with how Qlik Sense evaluates expressions or null values?
3. What steps can I take to troubleshoot and ensure the logic applies consistently to all rows?

Any insights or suggestions would be greatly appreciated.

Thank you!

[Qrishna]

we cannot determine just by seeing the field name, please provide the expression? if possible some sample data and expected output.