Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to make QV table display as 5 ?

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

8 Replies
MVP
MVP

Re: How to make QV table display as 5 ?

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 ?

Hi,

try

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

Regards

Regards,
Prashant Sangle
simone_spanio
Valued Contributor

Re: How to make QV table display as 5 ?

Paul,

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

S.

miguelbraga
Valued Contributor III

Re: How to make QV table display as 5 ?

Hi Paul,

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

Regards,

MB

amit_saini
Honored Contributor III

Re: How to make QV table display as 5 ?

Paul,

Try this:

Thanks,
AS

balrajahlawat
Esteemed Contributor

Re: How to make QV table display as 5 ?

may be anything wrong in your expression??

simone_spanio
Valued Contributor

Re: How to make QV table display as 5 ?

MVP
MVP

Re: How to make QV table display as 5 ?

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.

Community Browser