4 Replies Latest reply: Dec 14, 2014 2:25 AM by Ashfaq Mohammed RSS

    Function and its usages

    P M

      Hi Experts,


      Anybody can have any documents on list Function and its usages which is frequently used in Qlikview data modelling.



      FirstSortedValue :-

      Returns the first value of expression sorted by corresponding sort-weight when expression is iterated over a number of records as defined by a group by clause.



      Load Customer,

      firstsortedvalue(PurchasedArticle, OrderDate) as FirstProductBought from abc.csv

      group by Customer;