Here i have attached the sample qvw.hope this will satisfy your requirement.
sg.qvw 148.2 K
Thanks for the help..
if I see from your file, you use straight table.
In my case, I can't get the valid value from partial sum in pivot table. (Pivot table > Properties > Presentation > Show Partial Sums)
For your information, I've tried RangeMax too, but it keep gives me zero value when I use Partial Sums in Pivot table.
Here, I've attached your file again with some additional changes.
Hope you can see that file, and you'll find the point what I meant.
Hi kogasawara and Navdeep Kumar,
Thanks for your help.
@kogasawara : I can't figure out with your expression. I think that expression is not suitable for my case.
as you can see, your expression works because there's no sum inside if condition. But in my case, i need to have sum expression inside if condition. e.g. : sum( if( sum(F1-F2)>0, sum(F1-F2), 0) )
however, this come out with a result in "error in expression".
This is what i'm facing right now :
=sum(if(F1-F2>0,F1-F2,0)) -> result OK, but i need to have sum inside if condition.
=if(sum(F1-F2)>0,sum(F1-F2),0)) --> it change the negative value to positive but it gives zero in total.
=sum( if( sum(F1-F2)>0, sum(F1-F2), 0) ) --> I need this kind of expression, but qlikview read it as an error. This is what I actually need.
anyone can help?