topic Re: Totals on Straight Table in QlikView

Totals on Straight Table

Tue, 22 Mar 2016 21:17:14 GMT

Good afternoon,

Hello

I have a straight table and I am creating totals for a particular column based upon breaks in another field.

I now have the following:

Account Number Acct Desc Balance Total

1234 Fred 1000 1200

1234 Fred 200 1200

1234 Fred 1200

I am having an issue blanking out the total in the first 2 rows.

Thanks,

Mitch

Re: Totals on Straight Table

swuehl — Tue, 22 Mar 2016 21:37:00 GMT

Is Total an expression, like

=Sum(Total<[Account Number]> Balance)

Then try

=If(Sum(Balance), '', Sum(Total<[Account Number]> Balance) )

Re: Totals on Straight Table

Wed, 23 Mar 2016 21:51:12 GMT

That ended up blanking out all the totals.

Any other thoughts?

Re: Totals on Straight Table

jepeerik — Wed, 23 Mar 2016 21:56:39 GMT

It looks like a Pivot Table instead of a Straight table.

On the Presentation tab Add the option of Show Partial Sums on the correct Dimension and turn on option Always Fully Expanded.

Re: Totals on Straight Table

swuehl — Wed, 23 Mar 2016 22:01:19 GMT

I think i haven't fully understood how your chart is built up.

Could you detail which dimensions and expressions you are using? Or post a small sample QVW?

Re: Totals on Straight Table

Wed, 23 Mar 2016 22:15:09 GMT

Table loaded

Effective Date	AccountNumber	Name	Zip	Balance
1/31/2016	56789	Joe	11345	10000
2/29/2016	56789	Joe	11345	1300
1/31/2016	77789	Mitch	43521	4500
1/31/2016	92345	Peter	46789	12345
2/29/2016	92345	Peter	46789	11111

Using this table, I want to create a straight table that shows the following:

Effective Date	AccountNumber	Name	Zip	Balance
1/31/2016	56789	Joe	11345	10000
2/29/2016	56789	Joe	11345	1300
	56789	Joe	11345	11300
1/31/2016	77789	Mitch	43521	4500
	77789	Mitch	43521	4500
1/31/2016	92345	Peter	46789	12345
2/29/2016	92345	Peter	46789	11111
	92345	Peter	46789	23456

The total line represents a break in AccountNumber, Name ,Zip.

I am getting everything except for the total amount.

Thanks

Re: Totals on Straight Table

swuehl — Wed, 23 Mar 2016 22:18:53 GMT

Ok, but how do you create the total line in your straight table? Still missing this piece.

Maybe just use a pivot table with partial sums instead?

Re: Totals on Straight Table

settu_periasamy — Thu, 24 Mar 2016 06:09:06 GMT

Hi,

May be try like this in your straight table..

In the Dimension limit Tab -> Check the "Show Total" option for your "Effective Date" Field.

Re: Totals on Straight Table

Thu, 24 Mar 2016 12:15:54 GMT

How did you do this?

When I do it, the totals break on Effective Date instead of AccountNumber

Re: Totals on Straight Table

Thu, 24 Mar 2016 13:24:10 GMT

Thanks Settu for the handy workaround.

Re: Totals on Straight Table

settu_periasamy — Thu, 24 Mar 2016 17:05:51 GMT

As i already mentioned,

In the Dimension limit Tab -> Check the "Show Total" option for your "Effective Date" Field.

Did you check the document?