Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
jagan
Luminary Alumni
Luminary Alumni

Hi Paul,

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

Regards,

jagan.

PrashantSangle

Hi,

try

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

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
simospa
Partner - Specialist
Partner - Specialist

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
Partner - Specialist III
Partner - Specialist III

Hi Paul,

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

Regards,

MB

amit_saini
Master III
Master III

Paul,

Try this:

Thanks,
AS

Anonymous
Not applicable

may be anything wrong in your expression??

jagan
Luminary Alumni
Luminary Alumni

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.