topic Re: Expression total showing incorrect? in QlikView

Expression total showing incorrect?

Tue, 15 Apr 2014 09:57:09 GMT

Hi,

I have straight table as below. When I made expression total it is not showing the count of ID correct. It is missing some records count. can anyone suggest me about this please?

Dimension	Count(StudentID)
	167
2nd class	45
3rd class	12
4th class	34
5th class	78

Thanks.

Re: Expression total showing incorrect?

its_anandrjs — Tue, 15 Apr 2014 10:00:52 GMT

Update:- You have to use Sum of rows because the expression total always give wrong values check the attached snap shot.

If you want to get Total then use

Try with

Count(StudentID)

And from chart properties >> Expressions >> Sum of rows instead of expression total

See the snap shot

Re: Expression total showing incorrect?

amit_saini — Tue, 15 Apr 2014 10:03:40 GMT

Hi Ameila,

In Total mode option please select as Sum

Thanks,

Re: Expression total showing incorrect?

jfkinspari — Tue, 15 Apr 2014 10:04:30 GMT

Or you might want to change to total mode to 'Sum' of rows

Re: Expression total showing incorrect?

MK_QSL — Tue, 15 Apr 2014 10:09:21 GMT

Aggr(Count(StudentID),Dimension)

Re: Expression total showing incorrect?

stabben23 — Tue, 15 Apr 2014 10:11:48 GMT

Hi,

or use the qualifier count( total <Dimension> StudentID).

Re: Expression total showing incorrect?

er_mohit — Tue, 15 Apr 2014 10:17:11 GMT

I think uncheck suppress zero value from presentation tab

or uncheck suppress when value is null from dimension side

Re: Expression total showing incorrect?

preminqlik — Tue, 15 Apr 2014 10:21:36 GMT

use the following expression :

sum(aggr(count(StudentID),Dimension1,dimension2))

Re: Expression total showing incorrect?

Tue, 15 Apr 2014 10:36:46 GMT

To get the correct total of all rows, you should use the Sum of rows option instead of using Expression total.