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

Sub totalling in Straight Table

thanks in advance. I'm using version 8.5 and I have created a straight table so show some sales data and have set to dynamic to show no. of rows. I would like to have 2 row at last to show the subtotaling and grand total. e.g.

Grand total = total no. of data is 100 rows

Sub-total = as configured (10 rows total if showing top 10 row, 20 rows total if showing top 20 row)

Grand total is ok to use the "total mode" in "Expressions" to get the sum of total.

However, I couldn't able to set the sub-total row as configured.

Is there anyone can help??

4 Replies
brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

subtotals are only in a pivot table possible.

Not applicable
Author

Hi

In straight table sub-total option are not available. so for that use pivot table

Anonymous
Not applicable
Author

HI Kenneth

It is not posible to get the sub total in the stright table ie straight table contain only indvl rows it will disply only particular total.

edg_baltazar
Partner - Creator
Partner - Creator

Now on QlikView 11 it's possible , in the Dimension Limits tab select Show Total of the dimension you want , Regards!