topic Re: Handing the New Values to Show in the Qlikview Script in QlikView

Handing the New Values to Show in the Qlikview Script

lakshmanvepuri — Tue, 26 Nov 2024 10:27:37 GMT

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

Re: Handing the New Values to Show in the Qlikview Script

Ruggero_Piccoli — Tue, 26 Nov 2024 10:46:12 GMT

Hi,

You are posting a question about QlikView Script in Qlik Reporting Service forum. I suggest you to post it in the QlikView instead https://community.qlik.com/t5/QlikView-App-Dev/bd-p/qlikview-app-development

Best Regards,

Ruggero

Re: Handing the New Values to Show in the Qlikview Script

MarcoWedel — Sun, 01 Dec 2024 13:47:00 GMT

maybe helpful:

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