Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Null() value logic in table (Undefined result vs Blank Character)

Dear Peers,

I will like to  seek help in handling undefined result (value divide by zero) and blank character in my data source as QV classify both scenarios as null value which fetch the same result.

Questions:

1) Is table logic 2 the only work around solution to match the result in data source? As i will like my total to be displayed in bold

2) Is there any solution to make the text box ignore or bypass null logic when multiple selection in the list box?

test2.jpg

"Null is unknown value, or undefined result. Other way to get null is from reading data from Excel worksheet where formulas result in null values. Typically text files cannot store null values. because always a null value is stored at flat text file, it's replaced by empty. That's right. Empty is not null. Empty is a value defined as not existing. While null is unknown value, empty is known as nothing. Technically, null is different from empty value. Empty is represented by '' (two simple quotes together) or, in some systems "" (two double quotes together). But, null has no representation, although it exists."

Source: How to Handle Null Values - Qknow

10 Replies
sunny_talwar

That is great.... if you are happy with what you got, I would suggest you to close this thread by marking correct and helpful responses.

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny