Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Total Line

In my Qlik project I do hae 4 collums :  vPUNIT_CV_I vPUNIT_CV_II VOL_CV_I and  the ohter is a formula:  (vPUNIT_CV_I - vPUNIT_CV_II)*vVOL_CV_I) - this is calculated for inflation.

I need in my tottal line the result of s single SUM of this formula but the QLIK calculated again the formula.

There is someone that could help me?

Regards ! !

10 Replies
avinashelite

could you elaborate with an example ?? or sample app

Anil_Babu_Samineni

I am not sure, I understand fully. Would you describe more

Sum(vPUNIT_CV_I)  - Sum(vPUNIT_CV_II) * Sum(vVOL_CV_I)

Or

(Sum($(vPUNIT_CV_I))  - Sum($(vPUNIT_CV_II))) * Sum($(vVOL_CV_I))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

Avinash,

please have a look at the attached file.

Not applicable
Author

!

Qlik_total_line.png

Anil_Babu_Samineni

If condition seems only you need to get values when 0. So this case if value of Scenary I or II is o then how you would get value devide 0 -- It should return Infinity for this case

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

I need to have the formula when the both fields where different of 0.

ANd I need to have a SUM of the values that is the result of the formula:

the click includes 357 in the total line

I nedd a sum of -75 + 0 + 23 -39 + 36 + 20 + 92 + 2 -17 + 66 -86 = total is 22

Anil_Babu_Samineni

Would you provide application, Please? For me it's difficult without seeing data

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Not applicable
Author

Saminedi,

How can I include my qvw here?

Not applicable
Author

Do you have an e-mail address ?