Count giving inaccurate result

PaReD_SF85 — Fri, 01 Oct 2021 16:45:51 GMT

I have a table in my new application that has only 1 of 6 columns not giving accurate counts, yet all columns are calculated the in the same manner.

Expression that should be resulting in 0 (zero): Count({<[Other]={'X'}>}[Type])

Others as above but substitute [Other] with [Soap], [Lotion], etc. (They are accurate totals based on the data)

Reference Table used and output results:

Type	Summed Type	Soap	Lotion	Towels	Rug	Bedding	Other
Condo	Owned	X			X	X
Rental	Non-Owned	X	X	X		X
Room Only	Non-Owned	X	X	X	X	X
House	Owned	X	X			X


Type	Summed Type	Soap	Lotion	Towels	Rug	Bedding	Other
Condo	Owned	9			9	9	9
Rental	Non-Owned	43	43	43		43	43
Room Only	Non-Owned	17	17	17	17	17	17
House	Owned	38	38			38	38
Total		107	98	60	26	107	107
Should be		107	98	60	26	107	0

Is 'Other' a reserved word by chance? I moved Other to not be right most column (thinking it was using it as a total column), but the results are the same.

Thank you in advance for your assistance!

Re: Count giving inaccurate result

PaReD_SF85 — Fri, 01 Oct 2021 19:53:02 GMT

I just added a line in the load to assign 'blank' when the field length is 0...and now it works. Not sure the difference to make it count as if nulls were the character 'X' though?

topic Re: Count giving inaccurate result in QlikView

Count giving inaccurate result

Re: Count giving inaccurate result