topic Re: How to apply Sum(Total) in Final_New field in QlikView

How to apply Sum(Total) in Final_New field

nitin_007 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

Final field is derived from Quantity * B.P, and in Final_New Field we want sum of final filed/sum of Quantity based on product. Below is the formula to derived the Final_New field.

=SUM(F2:F3)/SUM(D2:D3)

Like wise for all the products.

Also attached the same data.

Thanks in advanced.

Regards,

Nitin

Re: How to apply Sum(Total) in Final_New field

Frank_Hartmann — Wed, 23 Oct 2019 12:08:59 GMT

Maybe like attached

hope this helps

Re: How to apply Sum(Total) in Final_New field

sunny_talwar — Wed, 23 Oct 2019 12:08:03 GMT

Try this

Table: LOAD Plant, Product, Contract, Quantity, B.P, Quantity*B.P as final FROM [..\..\Downloads\Question_Community.xls] (biff, embedded labels, table is Sheet1$); Left Join (Table) LOAD Plant, Product, Sum(final)/Sum(Quantity) as Final_New Resident Table Group By Plant, Product;

Re: How to apply Sum(Total) in Final_New field

nitin_007 — Wed, 23 Oct 2019 12:18:22 GMT

Hi Sunny,

I want des output in front end expression.

Re: How to apply Sum(Total) in Final_New field

sunny_talwar — Wed, 23 Oct 2019 12:22:21 GMT

What dimensions do you have in your front end table? Also, is final (field) calculated in the script or is that something which you need calculated in the front end too?

Re: How to apply Sum(Total) in Final_New field

nitin_007 — Wed, 23 Oct 2019 12:42:08 GMT

Dimensione field is plant , Product, Contract.

final field is calculated in front end only, quantity*B.P=Final

Re: How to apply Sum(Total) in Final_New field

sunny_talwar — Wed, 23 Oct 2019 13:05:15 GMT

Try this

Sum(TOTAL <Plant, Product> Quantity*B.P)/Sum(TOTAL <Plant, Product> Quantity)

Re: How to apply Sum(Total) in Final_New field

nitin_007 — Thu, 24 Oct 2019 06:48:49 GMT

Hi Sunny,

Could you send me test.qvw application using my attached data.

Re: How to apply Sum(Total) in Final_New field

sunny_talwar — Thu, 24 Oct 2019 10:46:05 GMT

PFA

Re: How to apply Sum(Total) in Final_New field

Brett_Bleess — Thu, 31 Oct 2019 18:32:40 GMT

Nitin, did Sunny's sample app get you everything you needed? If so, do not forget to come back to the thread to mark that post using the Accept as Solution button to give credit for the help you received, and to let others know that worked. If you are still working on things, please leave an update.

Regards,
Brett