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

[Anonymous]

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?

"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

[beck_bakytbek]

Hi Nelson

look at this: Convert Null values using NullAsValue statement in QlikView - YouTube and try to implement it

hope that helps

beck

[sunny_talwar · Accepted solution]

Bold like this?

Not sure what you need for 2? Can you elaborate?

[Anonymous]

Thanks Sunny.

For point 2, will like to have this result when Dept.CTR selected is I and J at the same time. Trying code it to passby null logic to display sum of table results for >1 selection in list box.

[sunny_talwar]

What is the null logic you are talking about? I am not sure I understand what you mean

[Anonymous]

Just need the below result when I and J is selected.

[sunny_talwar]

You are already getting this when I and J are selected, what is missing? Color or text?

[Anonymous]

Both. Should be green and text "Better off target missing"

[sunny_talwar]

Not entirely sure, but try the attached

[Anonymous]

Not exactly what I wanted as this logic will always return "Green" in color and "Better Than Target" for any multiple selection.

I managed to resolve this by creating NullFlag at script level (set "NA" as 1) and use it on my expression to bypass those status in "NA" for my aggregation.

how to calculate total while populating null as... | Qlik Community

Anyway appreciate your help on the first question.