topic Re: The problem about "Total" in QlikView

The problem about "Total"

Tue, 14 Jan 2014 10:09:01 GMT

I create a pivot table.

But it occurs an issue about the "Show Partial Sums".

I don't know why. Need for help !!!

My pivot table is below:

Re: The problem about "Total"

ljackson — Tue, 14 Jan 2014 10:11:26 GMT

Can you upload your file?

Re: The problem about "Total"

Colin-Albert — Tue, 14 Jan 2014 10:11:43 GMT

Can you post the expressions you are using on your chart?

Re: The problem about "Total"

Tue, 14 Jan 2014 10:25:03 GMT

may help you to attach your app

http://community.qlik.com/docs/DOC-1290

Re: The problem about "Total"

mjm — Tue, 14 Jan 2014 10:33:20 GMT

Hello CoCo,

Can you please upload your App so that we can take a look in more depth?

Re: Re: The problem about "Total"

Wed, 15 Jan 2014 05:48:18 GMT

Hello,

The attachments are my QVW file and QVD file.

Please have a look. Thanks.

Re: Re: The problem about "Total"

Wed, 15 Jan 2014 05:54:07 GMT

Hi,

My App and QVD file are attached.

Please have a look. Thanks.

Re: The problem about "Total"

jagan — Wed, 15 Jan 2014 06:04:42 GMT

Hi,

Use Aggregation functions like Sum,

Sum(Col1)

in all the expressions.

Regards,

Jagan.

Re: The problem about "Total"

NareshGuntur — Wed, 15 Jan 2014 06:11:55 GMT

Hi CoCo,

You should use Sum in all the expressions.

Sum(Col1), Sum(Col2).......

When you use this, you'll get the Totals as well but doubled as you haven't dropped the main table. The two tables are getting concatenated.

Please see the attached QVW.

Hope this is clear.

Cheers,

Naresh

Re: The problem about "Total"

Wed, 15 Jan 2014 06:23:58 GMT

Hi ,

It works. Thanks too much.

Re: The problem about "Total"

Wed, 15 Jan 2014 06:29:48 GMT

Hello,

Thanks too much.

I can't open the attached QVW as I used the "QlikView Personal Edition".

Then I follow your advice, just save a single table in the script, it works correctly.

Cheers,

CoCo

Re: The problem about "Total"

kiranmanoharrode — Wed, 15 Jan 2014 06:34:56 GMT

Dear CoCo Xi,

You must have to use Sum() (aggregation Function) to aggragate values to dimensions used in Pivot table.

Regards,

Kiran Rode

+91 897 69 77 897

Re: The problem about "Total"

Wed, 15 Jan 2014 06:46:56 GMT

Hi,

Sum(Col2) will give you expected output. And also drop the table after Storing in QVD.

Hope this helps.

-Shruti