topic Simple But Strange Count in QlikView

Simple But Strange Count

haymarketpaul — Tue, 12 Feb 2013 14:12:39 GMT

Hi All

I've attached a qvw wherein i'm trying to do a simple count in a straight table chart of job titles. In the expression column i have =Count(job_title) which gives me 418.

However if i export the results to excel it seems to total 427 if i sum them up in excel?

I guess i'm missing something in Qlikview but i can't seem to figure out what? Please see attached qvw.

Any ideas welcome

Many thanks

Re: Simple But Strange Count

SunilChauhan — Tue, 12 Feb 2013 14:18:57 GMT

See the attached file

hope this helps

Re: Simple But Strange Count

vivientexier — Tue, 12 Feb 2013 14:20:58 GMT

418 is not your total but it is your number of blank lines.

Get rid of blank lines in your data.

Re: Simple But Strange Count

vivientexier — Tue, 12 Feb 2013 14:25:51 GMT

This answer is NOT correct.

This works but it is a bad practice to create a calculated dimension for this problem. Get ride of the problem in the loading process.

Re: Simple But Strange Count

haymarketpaul — Tue, 12 Feb 2013 14:27:38 GMT

Thanks for the reply - you are absolutely correct. i didn't realise some answers were blank.

Good advice.

Re: Simple But Strange Count

haymarketpaul — Tue, 12 Feb 2013 14:27:53 GMT

Perfect - Thanks

Re: Simple But Strange Count

SunilChauhan — Tue, 12 Feb 2013 14:30:57 GMT

Thanks for you reply.

Please let us know the way u are talking about .

definetely will be helpful in future.

Re: Simple But Strange Count

vivientexier — Tue, 12 Feb 2013 14:33:59 GMT

You used the "Len()" function. It is perfect.

But, it would be much better to resolve the problem once for all in the script than to correct the blank line in every chart.