I was trying to figure out the real usage of Rangemax and Rangemin. PLeas elook into tab two of the Qlikview file. I tried to import data from excel and also i used the following expression. But it is not working." =rangemax([Sales Value])"
This may help you understand better
Awesome QlikView functions – Range – QlikTab
View solution in original post
Tried the below expression and it is working fine without any issues. Thanks
=rangemax(sum(Quantity*[Amount Per Piece]))