Handing the New Values to Show in the Qlikview Scripting

[lakshmanvepuri]

Hi All

Need to update the Values in the Report from RED Columns to Green Columns

Vehicle	CODE	Reason Description	New_Vehicle	New_Code	New_Reason_ Description
LML	C1	To deliver next Week	TESLA	T1	To Deliver after 4 Months
HERO	HH1	To change the HeadLight	HONDA	HH2	To Change the SEATCOVER

IF(ISNULL(NEW_VEHICLE),VEHICLE,NEW_VEHICLE) AS CHANGE_NEW_VEHICLE,
IF(ISNULL(NEW_CODE),CODE,NEW_CODE) AS CHANGE_NEW_CODE,
IF(ISNULL(NEW_REASON_DESCRIPTION),REASON_DESCRIPTION,NEW_REASON_DESCRIPTION) As CHANGE_NEW_REASON_DESCRIPTION

Please amend the script and share your views

Thanks

[MarcoWedel]

maybe helpful:

https://help.qlik.com/en-US/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Scripting/Conditi...