Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Anonymous
Not applicable
Author

Try this:

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

View solution in original post

6 Replies
mazacini
Creator III
Creator III

Can you post an image of the table?

Not applicable
Author

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

Anonymous
Not applicable
Author

Hi,

Had you try with count(total Field)?

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

Not applicable
Author

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.

Anonymous
Not applicable
Author

Try this:

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

Not applicable
Author

Works great thank you!