Discussion Board for collaboration on QlikView Scripting.
I want to implement the following:-
1. Where the time_of_receipt field in straight table is blank I want to replace with the word 'PNR' in the image attached.
maye be :
if(len(trim(time_of_receipt))<1,'PNR',time_of_receipt) as time_of_receipt,
View solution in original post