Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

TextCount vs. Count vs. Count (Distinct)

Attached is the table I'm working with.    Notice that AccountNumber A817998 shows up twice, and the net ChargeAmount = zero.

QV is doing something I don't understand.  Using various expressions to count the   number of items in he table, I get different results:

  • TextCount (Unit) = 14.  This is also correct, if account A817998 is ignored.
  • Count (Unit) = 14.  This is also correct, if account A817998 is ignored.
  • Count (Distinct AccountNumber) = 15.  There are indeed 15 accounts in the table, but this expression considers account A817998.
  • Count (ChargeAmount) = 16.  There are a total of 16 entries in the table, including both entries for account A817998.

What I don't understand is why TextCount (Unit) and Count (Unit) ignore account A817998.  That is exactly what I'm trying to do , but I don't understand why QV is ignoring that account.

Any ideas?

4 Replies
Not applicable
Author

You'll need to give some more details on how exactly you got 14 because I put the spreadsheet into QV and got 16,16,15, and 16 which is what it should be as far as I know.  I can't imagine how count(Unit) could get a different number than count(ChargeAmount)... are you doing this in the script or something?

erichshiino
Partner - Master
Partner - Master

I tried to reproce your results, but I only got the expected results.

You can check my attachment.

Regards,

Erich

Not applicable
Author

Thanks, guys.  Attached is a screen capture of my QV screen.

I'm not doing anything odd in the script.  Just loading 3 files (2 QVDs and 1 Excel).

I don't understand it either.  Maybe I don't understand how TextCount () works.  How is it different from Count()?.  The help file wasn't very helpful.

erichshiino
Partner - Master
Partner - Master

You can include other 'counts' to better understand your result.

Try numericcount(), and nullcount()

count() will ignore nulls

nullcount() only for nulls

numericcount() will count only numbers (ignore text and nulls)

I guess textcount() ignores numbers

Hope this helps,

Erich