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 Script

Hi All

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
142 Views
0 Likes
2 Replies
Ruggero_Piccoli
Support
Support
2 weeks ago

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



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
138 Views