10 Replies Latest reply: Jun 8, 2015 2:49 AM by Jonathan Dienst RSS

    Connecting a key field in table A to two fields in table B

    Hasvine Dhurmea

      Hello Everyone,

       

      I have a big issue. I have two tables.

      Table A where I have the user ID (user ID is the key field) and the ID name.

       

      And table B which provides information on tickets opened and in this table i have the field of:

      i) the user who created the ticket (Requestor)

      ii) the user who closed the ticket(user ID).

      Currently the key field is connected with the user who solved the ticket.

       

      Right now I need to build a bar chart where my Dimension is the 'ID name' and the number of tickets created by the users for the last 5 days.

       

      My expression is as follows:

       

      =Count({<Date={'>=$(=Date(Max(Date)-5))<=$(=Date(Max(Date)))'}>} Requestor)

       

      However, Qlikview is showing the good dimension but is counting the user ID(the user who closed the ticket).

       

      Could you please help.

       

      Many Thanks,

       

      Hasvine