Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

If condition with time format

Hi,

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.

1 Solution

Accepted Solutions
Highlighted
Master
Master

maye be :

if(len(trim(time_of_receipt))<1,'PNR',time_of_receipt) as time_of_receipt,
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

1 Reply
Highlighted
Master
Master

maye be :

if(len(trim(time_of_receipt))<1,'PNR',time_of_receipt) as time_of_receipt,
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post