Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
jwaligora
Creator
Creator

Set Analysis: {"*"} as a condition counts nulls.

Is the orange output considered expected behaviour? 

odd.png

The straight table for the top data set counts records where 'ss' is not null - as expected.

The straight table for the bottom data set counts records where 'dd' is null - this only happens when the column upon which the condition is placed contains ONLY nulls. This seems highly inconsistent from a mathematical standpoint - is it an expected behaviour of set analysis?

Thanks,
J

1 Solution

Accepted Solutions
hic
Employee
Employee

Now that I see your data, I understand what happens: There are no values at all in the field "dd". Then the selection {<dd={"*"}>} fails, and the count function will count all records.

However, if you add a value to "dd", everything works OK:

Henric_Cronstrm_0-1649402228671.png

 

This is a known limitation, that only occurs for empty fields with no values at all.

View solution in original post

4 Replies
hic
Employee
Employee

No, it shouldn't count NULLs, so I suspect that something else is wrong. What happens if you add a second expression "=IsNull(dd)" ?

 

jwaligora
Creator
Creator
Author

Hi.

jwaligora_0-1649349777870.png

I'm also attaching the file(s). 

I wish I had an idea to contribute, but I'm just plain unsure of what's what. Any insights will be of help.

Thanks,
J.

hic
Employee
Employee

Now that I see your data, I understand what happens: There are no values at all in the field "dd". Then the selection {<dd={"*"}>} fails, and the count function will count all records.

However, if you add a value to "dd", everything works OK:

Henric_Cronstrm_0-1649402228671.png

 

This is a known limitation, that only occurs for empty fields with no values at all.

jwaligora
Creator
Creator
Author

Thank you for confirming. I was not aware. 

Do you know of a location where this and possibly other limitations of similar nature are documented?