Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Mutiple Total Lines in Straight Table

I have a requirement to create a straight table with multiple 'total' rows at the bottom of the table e.g. one row for the sum, another for the average etc. and cannot find any simple way to do this apart from recreating the straight table with averages and then trying to hide it behind the first straight table with just the averages row showing in the second row. Any pointers would be really appreciated, thanks in advance.

5 Replies
santhoo_san
Partner - Creator II
Partner - Creator II

see if this helps

buzzy996
Master II
Master II

i think u can use dimensionality() to do those things.

Anonymous
Not applicable
Author

Mucho gracias to santhosh Using the dimension limits is the simplest and most elegant solution here. Thanks a ton!

Anonymous
Not applicable
Author

And now I have a second issue to work on, is it possible to show the dimension limit total for only some of the measure columns but not others?

Anonymous
Not applicable
Author

Figured that out using dimensionality, thanks to both shiva and santhosh again.