topic Function &quot;above&quot; in QlikView https://community.qlik.com/t5/QlikView/Function-quot-above-quot/m-p/146777#M25293 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />I have problem with function "above" in QV Pivot Table (see attachment). If I create 2 dimensions (Month+ Cusomer Name) and then create field with function "above", this function does not work as expected. Could you, please, explain how to make this function working. I expect function above (sum(SalesAmount)) for the 2'nd line should return 782.99.</P><P>Thanks,<BR />Ramunas</P><P></P></BODY></HTML> Mon, 15 Jun 2009 18:41:08 GMT 2009-06-15T18:41:08Z Function "above" https://community.qlik.com/t5/QlikView/Function-quot-above-quot/m-p/146777#M25293 <HTML><HEAD></HEAD><BODY><P>Hi,<BR />I have problem with function "above" in QV Pivot Table (see attachment). If I create 2 dimensions (Month+ Cusomer Name) and then create field with function "above", this function does not work as expected. Could you, please, explain how to make this function working. I expect function above (sum(SalesAmount)) for the 2'nd line should return 782.99.</P><P>Thanks,<BR />Ramunas</P><P></P></BODY></HTML> Mon, 15 Jun 2009 18:41:08 GMT https://community.qlik.com/t5/QlikView/Function-quot-above-quot/m-p/146777#M25293 2009-06-15T18:41:08Z Function "above" https://community.qlik.com/t5/QlikView/Function-quot-above-quot/m-p/146778#M25294 <HTML><HEAD></HEAD><BODY><P>If you change the order of your dimensions (Customer_Name, Month instead of Month,customer_name) , it works.</P><P>It is because you have only one customer and the above function works on the above value of the last dimension used.</P><P>Hope that helps.</P><P></P><P>Philippe</P><P></P></BODY></HTML> Mon, 15 Jun 2009 19:46:27 GMT https://community.qlik.com/t5/QlikView/Function-quot-above-quot/m-p/146778#M25294 2009-06-15T19:46:27Z