topic stright table in QlikView

stright table

srinivasa1 — Tue, 01 Mar 2011 06:10:02 GMT

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

stright table

Tue, 01 Mar 2011 06:15:01 GMT

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.

stright table

srinivasa1 — Tue, 01 Mar 2011 06:59:01 GMT

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

stright table

deepakk — Tue, 01 Mar 2011 07:40:58 GMT

hi Srini,

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

stright table

Tue, 01 Mar 2011 08:52:59 GMT

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.