4 Replies Latest reply: Apr 18, 2013 2:07 AM by jagan mohan rao appala RSS

    Script Issue with MAX function

           Hello all,


      I'm new to Qlikview.


      I have a situation like i got 100 million product details.

      where productID will be unique but when ever the details changes we will have a new productdetailID.


      I have to pick a latest one.

      & My table have only ProductID & ProductDetailID fields.


      when i'm using MAX function & grouping by ProductID.

      I'm getting an invalid expression in script.

      I tried MAXNUM which didn't worked.



      Can anyone help me with this issue please.



      thanks a lot to you all.