topic Re: SUBTOTALS IN STRAIGHT TABLE in QlikView

SUBTOTALS IN STRAIGHT TABLE

Mon, 03 Mar 2014 20:46:23 GMT

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?

Re: SUBTOTALS IN STRAIGHT TABLE

Mon, 03 Mar 2014 21:17:46 GMT

Hey Ray,

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

Thanks

Re: SUBTOTALS IN STRAIGHT TABLE

Peter_Cammaert — Mon, 03 Mar 2014 21:27:59 GMT

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.

Re: SUBTOTALS IN STRAIGHT TABLE

Tue, 04 Mar 2014 12:49:16 GMT

No Attachment

Re: SUBTOTALS IN STRAIGHT TABLE

Peter_Cammaert — Tue, 04 Mar 2014 14:07:55 GMT

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

Re: SUBTOTALS IN STRAIGHT TABLE

Tue, 04 Mar 2014 20:23:45 GMT

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

Re: SUBTOTALS IN STRAIGHT TABLE

alexbjorlig — Wed, 23 Sep 2015 10:47:20 GMT

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

Re: SUBTOTALS IN STRAIGHT TABLE

jonathandienst — Wed, 23 Sep 2015 14:23:52 GMT

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