Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
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
mov
Esteemed Contributor III

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

Try this:

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

6 Replies
mazacini
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)?

QV_Screen_Capture.png

rominavilla
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.

mov
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!

Community Browser