Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
lakshmanvepuri
Creator
Creator
2 weeks ago

Handing the New Values to Show in the Qlikview Scripting

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

Labels (3)
Labels
111 Views
1 Reply