Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum of rows Pivot table

Hi,

I have one straight table and one pivot table in which I want to sum up the total where 0,1-0,5 sums up to 0 and 0,6-0,9 sums up to 1.

In the straight table I have marked Sum of Rows in the total mode in the expression tab and that sums up to a correct number. The expression is Round(Sum)(Full_equivalents))

Then I have a pivot table showing months on the X axis and suppliers on the Y axis. In the pivot table I can´t make any changes in the expression tab, i.e. I can´t mark the Sum of Rows in the total mode and therefore it is not summing up the totals correct.

Have anyone had a similar problem? I don´t see why it sums up differently since it gathers data from the same database

Thanks!

Sofie

4 Replies
Henric_Cronström

Can you not just use Round(Sum(...),1) ?

In my opinion, you should avoid "Sum of Rows", since the straight table then may show a number which is different from what the data suggests. The only case when "Expression total" and "Sum of Rows" show different numbers, is when a record (or dollar or unit) can belong to two different rows in the chart. Then it will be counted twice if you use "Sum of Rows" and once if you use "Expression total ".

HIC

Not applicable
Author

What is the ),1) for? What I can see nothing happens when I add that.

Thanks for the info. However when I use "Sum of Rows" the sum is lower than if I use "Expression Total" and the "Sum of Row" is the correct calculation and therefore I want to have the same output in the pivot table

Sofie

Henric_Cronström

The 1 simply defines to what it should round. But you're right - if you want to round to integers, it is redundant. It will round to integers in either case.

Can you post an example?

HIC

Not applicable
Author

I´m sorry but I´m new to Qlikview, where do I post an example? Do I share the whole project?

Thanks 😃