Discussion Board for collaboration on QlikView Scripting.
I crated Pviot table with values Sum(A) adn Sum(B). I want to take diffrence between these two values.
I created a varibale vDiff=Sum(A)-Sum(B). Its giving me a total aggregation difference.
Please let me know how to only difference between Sum(A) and Sum(B) specific to that row only.
Take A and B as Dimensions.
Now add an expression RangeSum(A)-RangeSum(B)
Hope this helps.
Add one more expression in pivot table with Expression label1-Expression label 2.
which will be nothing but Sum(A) -Sum(B) specific to that row only.
Give names for Sum(A) and Sum(B), for example let say you give Sum(A) as colA and colB for Sum(B). Now you can write colA - colB and you will get your desire result.
RangeSum will work.
Please see if that helps.
write third expression as
You can use labels assigned to Sum(A) and Sum(B). Check this
Please send the code I am working on Personal Edition
But I want to assign a varibale to Sum(A)-Sum(B).
Do you want to store difference for any particular row in the variable? What is the condition to select that row?