Discussion board where members can get started with QlikView.
I tried to find a solution in existing discussions but were not successful.
I have this expression in a straight table to calculate New Freight:
vSaleSize is my variable.
But when I sum this expression , it returns 0 in Total.
Can you help me please on that point.
Try setting the Total Mode of your expression to Sum Of Rows
View solution in original post
if(vSaleSize<(sum([SaleAmount])), 0 ,[Freight])
Or what is the definition of the vSaleSize variable.
if(vSaleSize < (sum(TOTAL [SaleAmount])), 0 ,[Freight])
Thank you so much Marcus.
I never think about this option.
Thank you for your help Anand.
Have a nice day,