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.

       

      Like:

      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.

       

      Example:

      Load Customer,

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

      group by Customer;

       

      Thanks,

      Prashant