topic Re: How to make QV table display as 5 ? in QlikView

How to make QV table display as 5 ?

paulyeo11 — Fri, 08 Jan 2016 07:45:59 GMT

Hi All

My QV Table , display total sum wrong. How to make it correct ?

I will post my QV Doc in my next post.

Paul

Re: How to make QV table display as 5 ?

jagan — Fri, 08 Jan 2016 07:53:25 GMT

Hi Paul,

If you are using Straight table then choose some of rows in Expression tab for the expression.

Regards,

jagan.

Re: How to make QV table display as 5 ?

PrashantSangle — Fri, 08 Jan 2016 08:06:12 GMT

Hi,

try

sum(aggr(sum(YourExpre),dim1,dim2..))

Regards

Re: How to make QV table display as 5 ?

simospa — Fri, 08 Jan 2016 10:18:00 GMT

Paul,

if you can't post a .qvw, post a screenshot of your table to try to help you in the best way.

Re: How to make QV table display as 5 ?

miguelbraga — Fri, 08 Jan 2016 10:25:27 GMT

Hi Paul,

There is no suficcient information for us to help you. Can you please describe your issue better?

Regards,

Re: How to make QV table display as 5 ?

amit_saini — Fri, 08 Jan 2016 10:30:25 GMT

Paul,

Try this:

Thanks,
AS

Re: How to make QV table display as 5 ?

Anonymous — Fri, 08 Jan 2016 10:42:50 GMT

may be anything wrong in your expression??

Re: How to make QV table display as 5 ?

simospa — Fri, 08 Jan 2016 12:44:06 GMT

You are using Pivot table. Take a look here:

incorrect calculated summary in pivot chart

Incorrect totals in a pivot table using set analysis

Wrong total value in pivot table .

Incorrect TOTAL in pivot table

Wrong total in pivot table

Re: How to make QV table display as 5 ?

jagan — Mon, 11 Jan 2016 01:00:02 GMT

Hi Paul,

Since you are using Pivot table, Sum of Rows option is not available. To get the correct value try like below

=Sum(Aggr(Sum(MeasureName), Dimension1, Dimension2., ......DimensionN))

Note: In above expression replace MeasureName and Dimension1, Dimension2., ......DimensionN with your actual fields.

Hope this helps you.

Regards,

Jagan.