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

Totals in Table

Hello,

Is it possible to show more totals in a table.

In Chart properties -> Expressions -> Total mode  only one.

I wanna see the max, min, average and sum of each range.

Gr,

Ralph

7 Replies
MK_QSL
MVP
MVP

If you want to show everything together, you can have New Statistics Box..

Go to empty space and right click and select New Sheet Object

Now Select New Statistics Box and use whatever Fields you want with Available Functions..

luis_pimentel
Partner - Creator III
Partner - Creator III

I agree with Manish, probably a Statistics box would help you.

Not applicable
Author

Hello Manish,

Thanks for the quick response.

The answer is good if I have 1 range.

My question was not clear.

I have one straight table with 10 ranges (10 columns; like temperature 1, temperature 2, pressure 1 etc.) and for eache range i want to see the max temp. Min temp. and average temp in the same table.

Gysbert_Wassenaar

A column can have only one total. If you want to show other totals you need to add more expression columns.

Or perhaps create another table that only shows the totals (min, max and avg) for each of the 10 ranges.


talk is cheap, supply exceeds demand
Not applicable
Author

Goedemiddag Gysbert,

I gonna try it, let you know if it works.

Thanks.

sunilkumarqv
Specialist II
Specialist II

Please find attached file. Hope this will help to you.

Anonymous
Not applicable
Author

See attached.  Don't ask about a better presentation 🙂