6 Replies Latest reply: Aug 8, 2013 1:00 PM by Siddharth Mulchandani RSS

    Including a sum statement into Firstsorted value

      Hello I have a problem. I am getting a null value because there are two records in my table with the same date, which is fine, but Qlikview displays this as a null, I have used expression FirstSortedValue([Cleared Amount],-Date) I would like to use FirstSortedValue(SUM[Cleared Amount]),-Date) but Qlikview doesnt like it, I could do a resident load but the report takes over an hour to reload.


      Is is it possible to use sum in a firstsortedvalue statement?