Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

haymarketpaul
Contributor III

Simple But Strange Count

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

1 Solution

Accepted Solutions
SunilChauhan
Esteemed Contributor

Re: Simple But Strange Count

See the attached file

hope this helps

View solution in original post

7 Replies
SunilChauhan
Esteemed Contributor

Re: Simple But Strange Count

See the attached file

hope this helps

View solution in original post

vivientexier
Contributor II

Re: Simple But Strange Count

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

Get rid of blank lines in your data.

vivientexier
Contributor II

Re: Simple But Strange Count

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.

haymarketpaul
Contributor III

Re: Simple But Strange Count

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

Good advice.

haymarketpaul
Contributor III

Re: Simple But Strange Count

Perfect - Thanks

SunilChauhan
Esteemed Contributor

Re: Simple But Strange Count

Thanks for you reply.

Please let us know the way u are talking about .

definetely will be helpful in future.

vivientexier
Contributor II

Re: Simple But Strange Count

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.