9 Replies Latest reply: Jan 23, 2013 5:52 AM by leviwong RSS

    Populated calculated field in script

      Hi Guys,

       

       

      Just started using Qlikview and I think maybe I am being slow.

       

      I have a table:

       

      Title: Tbl_Request

       

      Fields: RequestID

       

      I want to be able to load another field which counts the number of each RequestIDs which are found for each record.

       

      eg:

       

      RequestID:     Count:

      10                        3

      10                        3

      10                        3

      25                        1

      20                        1

      19                        1

      20                        2

      20                        2

       

       

      Is there a way to calculate this field using a LOAD statement?

       

      Tbl_Request:

      LOAD RequestID,

      <<<Expression for Count Field>>> As Count;

      SQL SELECT *

      FROM RequestAction;

       

      Any help would be appreciated.

       

      Many Thanks

       

      L