3 Replies Latest reply: Jun 19, 2017 2:00 PM by David Forest RSS

    Association two fields, one calculated

    Tristen Hannah

      Hi, I'm trying to create an association between two tables.  Table A has state and date, the Table B has state and week ending date.  I created a calculated field for week ending date in Table A.  When I try to create graphs on date, it shows one of the data sets by time, and lumps the rest into a bar, as if the association isn't working.  Image below.

       

      I created test tables joining on state and date, no calculated fields, and it worked correctly.  I also created test tables joining on dates, one week ending, the other calculated to week ending, and that worked fine.  Having trouble with both at the same time.

       

       

      qlikq1.PNG

       

       

       

        

      we_datevaluebstate
      1/8/2017100AZ
      1/15/2017110AZ
      1/22/201790AZ
      1/8/2017200TX
      1/15/2017190TX
      1/22/2017210TX

       

        

      datevalueastate
      1/2/201712AZ
      1/3/201712AZ
      1/4/201712AZ
      1/5/201712AZ
      1/6/201712AZ
      1/7/201712AZ
      1/8/201712AZ
      1/9/201712AZ
      1/10/201712AZ
      1/11/201712AZ
      1/12/201712AZ
      1/13/201712AZ
      1/14/201712AZ
      1/15/201712AZ
      1/16/201712AZ
      1/17/201712AZ
      1/18/201712AZ
      1/19/201712AZ
      1/20/201712AZ
      1/21/201712AZ
      1/22/201712AZ
      1/2/201724TX
      1/3/201724TX
      1/4/201724TX
      1/5/201724TX
      1/6/201724TX
      1/7/201724TX
      1/8/201724TX
      1/9/201724TX
      1/10/201724TX
      1/11/201724TX
      1/12/201724TX
      1/13/201724TX
      1/14/201724TX
      1/15/201724TX
      1/16/201724TX
      1/17/201724TX
      1/18/201724TX
      1/19/201724TX
      1/20/201724TX
      1/21/201724TX
      1/22/201724TX

       

       

      qlikq2.PNG

       

      qlikq3.PNG