Discussion Board for collaboration related to QlikView App Development.
My data looks like this
The chart should look like this
My expression looks like this
sum(aggr(if (Cost > 0, (sum(Price)- sum(Cost))/sum(Price)) ,Cust))
But this brings up 75% + 66% = 141%
I am using "Show percanatge option" in Numbers tab to show percantage.
If I remove sum from in front of expression the Total row comes out as blank.
what am I doing wrong here?
Go to Solution.
Thanks for replying.
I tried that but It did not work.
I did something like this to make it work.
- sum(aggr(if (Cost>0,sum(Cost)),Cust)))
View solution in original post
I believe you are using a straight table with Cust Dimension , so no need to use aggr, below expression must suffice:
if (Cost > 0, (sum(Price)- sum(Cost))/sum(Price))
Please check and let me know if that does not work