I have the following question. I hope you can support.
I loaded a table in Qlik Sense called [Weekly BFE Monitoring Report] including columns [BFE Responsible] and [Prog Code].
Now I want to modify the values of the column [BFE Responsible] to "Not Applicable" ONLY if the value of [Prog Code] is equal to "P". For the rest of values of column [Prog Code], values of column [BFE Responsible] should remain unchanged.
I tried with the following code but it is not giving the expected results:
[Weekly BFE Monitoring Report]: LOAD If ([Prog Code] = 'P', 'Not Applicable') as [BFE Responsible] resident [Weekly BFE Monitoring Report];