topic Re: Total Line in QlikView

Total Line

Mon, 20 Mar 2017 14:58:25 GMT

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 ! !

Re: Total Line

avinashelite — Mon, 20 Mar 2017 15:00:36 GMT

could you elaborate with an example ?? or sample app

Re: Total Line

Anil_Babu_Samineni — Mon, 20 Mar 2017 15:22:39 GMT

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

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

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

Re: Total Line

Mon, 20 Mar 2017 16:05:07 GMT

Avinash,

please have a look at the attached file.

Re: Total Line

Mon, 20 Mar 2017 16:21:22 GMT

Re: Total Line

Anil_Babu_Samineni — Mon, 20 Mar 2017 16:26:06 GMT

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

Re: Total Line

Mon, 20 Mar 2017 16:34:22 GMT

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

Re: Total Line

Anil_Babu_Samineni — Mon, 20 Mar 2017 16:42:29 GMT

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

Re: Total Line

Mon, 20 Mar 2017 17:00:16 GMT

Saminedi,

How can I include my qvw here?

Re: Total Line

Mon, 20 Mar 2017 17:00:33 GMT

Do you have an e-mail address ?

Re: Total Line

Mon, 20 Mar 2017 17:26:36 GMT