Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Sean_BI
Creator
Creator

How to handle NULL comparion in qv scrpts

Hi, 

I have a typcial case where when NULL is compared in scripts results no error in log files for QV 12.3 Nov2018 edition, where as the same condition returns (Error: Script line error: ) in the document log for QV 11.0.

Example: 

I am trying to compare a max_date with another max_date_N, the script silently complete without any error, which should not be the case. 

Version: qv12.3 nov 2018

IF $(vQVDLastPeriod) < $(vDBLastPeriod) --> here qDBLastPeriod returns null, then script silently executes and logs as Execution finished . This will cause isssue in having any entry in last_excution_time in my  audit_table.qvd

Version: qv 11.0

IF $(vQVDLastPeriod) < $(vDBLastPeriod) --> here qDBLastPeriod returns null, then script failed with error. 

I've see this article, but did not understand the work around.

https://support.qlik.com/articles/000080222?_ga=2.247680450.496770407.1589446614-1640766963.15894459...

Should i make any changes in settings.ini file by disabling  (EnableBnfReload=0) and if yes, does this impact existing  scripts.

Appreciate if you can help.

1 Reply
Brett_Bleess
Support (Former)
Support (Former)

I would not recommend using the setting, as that was deprecated in 12.30 track and in 12.40 and later the setting is completely ignored, so the better option is to correct the actual issue.  I would think doing an isnull() check and if so, exit the script or something would be a potential way to go I think, but I am not exactly sure what it is you are really doing and that may be why nobody else answered, so some further use case details may be helpful.  

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.