Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Sum of Rows not working

Hi,

I need to show number of top deals in a table. Users input the number from a Input box (variable vTopValue). This variable is used in Max Number (presentation tab) to display the user specified number of top deals.

However, even if I set the Total Mode as Sum of Rows, the total still displays expression total. How do I just show the total of the displayed rows?

I also tried to pass the variable in Dimension limits. But that doesn't work either. Seems it doesn't work for a calculated dimension.

Any suggestion how do I show the Sum of Rows?

Regards,

Bhaskar

Tags (3)
4 Replies
Highlighted
Specialist
Specialist

Re: Sum of Rows not working

Can you send me the expression used?

Highlighted
Specialist II
Specialist II

Re: Sum of Rows not working

Hi

In your expression, please write as below

Sum(AGGR (Sum (Sales)), Dimension)

This will solve sum of rows issue

Highlighted
Creator III
Creator III

Re: Sum of Rows not working

Hello Bhaskar,

Use AGGR Function in your expression

for example productwise  SalesAmount

=Sum(AGGR(SUM SalesAmount),ProductID))

Try this,

It will work.............

Regards,
Kiran Rode

+91 897 697 7897

Highlighted
Master III
Master III

Re: Sum of Rows not working

Check this app