Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Contributor II

stright table

im getting problem in stright table subtotal and individual rows total mismatching

Example like bellow

Region10 (sub total) of bellow rows mismatching

A

5

B

2

C

5



In this im adding individual rows it shows 12 but in sub total it's shows only 10 I kept straight table expression totoa mode as expression table.

Pls can anyone guide me why its happening thanks in advance.

srini

Tags (1)
4 Replies
Highlighted
Not applicable

stright table

Hi Srinivas,

If you are counting based on the rows its counting the value in the row so the value is 12 . But when you are using the sub total its is adding only the distinct value , so your value is 10..

Regards,

Chakravarthy.

Highlighted
Contributor II

stright table

hey thx for your reply....same thing for pivot table?

Highlighted
Partner
Partner

stright table

hi Srini,

In straight table change the expression totla to Sum of total. It will give you 12.

Highlighted
Not applicable

stright table

Hello Srini,

In Pivot Table you can do show sub total.

But in straight table do the "sum of rows" in Total mode under expression tab...It will give 12 as result.