Discussion Board for collaboration related to Creating Analytics for QlikView.
The strange thing is, when I use this the chart only show 3 negative values.. But your answer got it almost right:
SUM((Streefperc*Maxhuur))-SUM(Nettohuur) Did the trick. Because of some strange reason using the variable Streefhuur (which calculates streefperc*maxhuur) was the bottleneck.
I thank you sir!
I already tried this one, didn't work