Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Partial sum is not calculated

Hi, I have a pivot table and I calculated a column with the following fomula: =Sum(filed1)+Sum(Field2)+Sum(Field 3)

At this column the partial sum is not calculated. If I calculate it in the excell file I am geting my data from, the partial sum is working.

Any advise is welcome.

Thank you

Tags (2)
1 Solution

Accepted Solutions

Re: Partial sum is not calculated

You expression should look like this

=RangeSum(Sum(Luni*PU_furnizor)

,Sum(Marti*PU_furnizor)

,Sum(Miercuri*PU_furnizor)

,Sum(Joi*PU_furnizor)

,Sum(Vineri*PU_furnizor))

4 Replies

Re: Partial sum is not calculated

If there is a possibility of null values you can try with

RangeSum(Sum(field1),Sum(field2),Sum(field3))

Celambarasan

Not applicable

Re: Partial sum is not calculated

Dear Sir, thank you for your answer,  I tried the formula but it is still not working. I am uploading the QV file I am working on, please observe the last two columns, they should show the same values. The first one is with the formula you proposed, the second one collects the data from the excell file, where I calculated the final value. Please collaps the rows in the pivot table, and the value becomes zero.

The project is about calculating the catering costs based on a unit price and the presence of the kids in the 5 working days of a week.

Thank you

Re: Partial sum is not calculated

You expression should look like this

=RangeSum(Sum(Luni*PU_furnizor)

,Sum(Marti*PU_furnizor)

,Sum(Miercuri*PU_furnizor)

,Sum(Joi*PU_furnizor)

,Sum(Vineri*PU_furnizor))

Not applicable

Re: Partial sum is not calculated

Thank you, now it works.

Community Browser