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.