Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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."
Hi Nelson
look at this: Convert Null values using NullAsValue statement in QlikView - YouTube and try to implement it
hope that helps
beck
Bold like this?
Not sure what you need for 2? Can you elaborate?
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.
What is the null logic you are talking about? I am not sure I understand what you mean
Just need the below result when I and J is selected.
You are already getting this when I and J are selected, what is missing? Color or text?
Both. Should be green and text "Better off target missing"
Not entirely sure, but try the attached
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.