Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ! !
could you elaborate with an example ?? or sample app
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))
Avinash,
please have a look at the attached file.
!
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
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
Would you provide application, Please? For me it's difficult without seeing data
Saminedi,
How can I include my qvw here?
Do you have an e-mail address ?