topic Sum of Rows not working in QlikView

Sum of Rows not working

bhaskarsharma03 — Mon, 19 May 2014 08:20:58 GMT

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

Re: Sum of Rows not working

Anonymous — Mon, 19 May 2014 08:26:06 GMT

Can you send me the expression used?

Re: Sum of Rows not working

satishkurra — Mon, 19 May 2014 08:33:57 GMT

In your expression, please write as below

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

This will solve sum of rows issue

Re: Sum of Rows not working

kiranmanoharrode — Mon, 19 May 2014 08:40:20 GMT

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

Re: Sum of Rows not working

anbu1984 — Mon, 19 May 2014 08:45:20 GMT

Check this app