# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
Not applicable

## How to get a sum row of a chosen dimension?

Hello,

When i create a straight table i usually use the simple expression Count(Field) so it adds a column to my straight table with a total number, but it also places a '1' next to every line. Is there a way to just get the total count in the first row and not all the 1's in every single line? Maybe a better expression or a way to remove the 1's?

1 Solution

Accepted Solutions
Esteemed Contributor III

## Re: How to get a sum row of a chosen dimension?

Try this:

if(dimensionality()=0, count(total Field), ' ')

6 Replies
Contributor III

## Re: How to get a sum row of a chosen dimension?

Can you post an image of the table?

Not applicable

## Re: How to get a sum row of a chosen dimension?

I still want that total number 12, but i don't want all of those 1's. Is there another way to take a total of a Company instead of adding an expression to the straight table of Count(Company)?

New Contributor III

## Re: How to get a sum row of a chosen dimension?

Hi,

Had you try with count(total Field)?

That returns 12 (in your case) in every row.

Not applicable

## Re: How to get a sum row of a chosen dimension?

I don't want numbers in every row. I just want one row with the total which is 12 in this case. All the other rows i want to be blank.

Esteemed Contributor III

## Re: How to get a sum row of a chosen dimension?

Try this:

if(dimensionality()=0, count(total Field), ' ')

Not applicable

## Re: How to get a sum row of a chosen dimension?

Works great thank you!