Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hi Everyone,

I have a problem. I have an existing application which I maintain and needed to  changed Data source from a bunch of flat files to SQL because of the refresh time. I have changed the syntax to work with SQL  and all the Data is coming in perfectly well compared to the flat files. The issue now is that one of the date field has null values and where ever there is an expression the null values get truncated which affect the entire report.

What do I do in this case. this report has 13 sheets with all types of chart but the table box seem to be showing the null values because there is no expression like you know.

Please, help my job is at stalk here. Thanks you all in Advance.

4 Replies
vikramv
Creator III
Creator III

Try to replace null values for the field with a character like 'space' or '_' or '-' etc...

Use the below function while loading the data from SQL.

SQL:

NVL(expr1,expr2) function:

If expr1 is null, then NVL returns expr2. If expr1 is not null, then NVL returns expr1.

Qlikequivalent:

if(isnull(expr1),'_',exp1)

try replacing exp2 with a character like '_' or '-' as Null() substitution

marcus_sommer
MVP & Luminary
MVP & Luminary

A very common approach to do further transformations to sql queries is the use of Preceding Load and I think also this: NULL handling in QlikView will be very helpful for you.

- Marcus

Not applicable
Author

I tried your suggestion, it only converted my entire fields to Null. I have isnull function on the sql and it is handling all my nulls. That is because table box and list box is showing all the nulls but anytime I have an expression with all chart types, it truncates the null values on the date field thereby making my calculations incorrect.

Has anyone come across this same issue? I need help. is an existing application that I just had to change the data source and I am not supposed to be having such issues since the front end is supposed to be the same.

Not applicable
Author

use ->        if(len(trim(field))=0, ... , ...)          to check the null value in the script!