SUBTOTALS IN STRAIGHT TABLE

[#1]

I am trying to shpw the Subtotal for a Group of Dimension in a Straight Table. Please see the attached file.

I am trying to show t he subtotal for (SUIT,Claim and NOI) and then Another Total for (HANDHOLD,MEDLIC,COVOPINIONMCARECAID).

Any Ideas?

[#2]

Hey Ray,

Attached is a simple example of how I would do this. Hope it helps you .

Thanks

AJ

[Peter_Cammaert]

In "What's new in QlikView 11" there is a nice example of applying dimension limits to get subtotals in a Straight table (otherwise pretty much impossible without a lot of work). On sheet "Dashboard", see the Monthly Regiuonal Sales object. Click the big i in the top right corner for an explanation.

If you don't like it, you may want to use a Pivot table. Has Subtotal feature built-in.

[#4]

No Attachment

[Peter_Cammaert]

What do you mean? Ajay's post has an attachment called "Test.qvw". I can open it without any problem.

[#6]

uR aTTACHEDMENT hELPED BUT i AM USING THE Straight Table not a Pivot Table and the reason is that I am  using some Mini Charts whihc is not avavavailable in PIVOT TABLE

[alexbjorlig]

Hi Peter. But the Sheet "Dashboard" with the object "Monthly Regional Sales" is a Pivot table?

[jonathandienst]

@Peter - Alex is right, it is a pivot. But I am curious, do you have any examples?