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.




      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?



      LOAD RequestID,

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

      SQL SELECT *

      FROM RequestAction;


      Any help would be appreciated.


      Many Thanks