topic Re: Null() value logic in table (Undefined result vs Blank Character) in QlikView

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

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

beck_bakytbek — Thu, 23 Mar 2017 12:45:58 GMT

Hi Nelson

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

hope that helps

beck

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

sunny_talwar — Thu, 23 Mar 2017 12:50:25 GMT

Bold like this?

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

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

Anonymous — Thu, 23 Mar 2017 15:41:21 GMT

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.

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

sunny_talwar — Thu, 23 Mar 2017 15:43:46 GMT

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

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

Anonymous — Thu, 23 Mar 2017 16:49:21 GMT

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

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

sunny_talwar — Thu, 23 Mar 2017 17:18:01 GMT

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

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

Anonymous — Thu, 23 Mar 2017 22:49:09 GMT

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

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

sunny_talwar — Fri, 24 Mar 2017 09:08:52 GMT

Not entirely sure, but try the attached

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

Anonymous — Tue, 28 Mar 2017 10:21:56 GMT

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.

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

sunny_talwar — Tue, 28 Mar 2017 11:00:26 GMT

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