Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Association two fields, one calculated

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

3 Replies
ahaahaaha
Honored Contributor

Re: Association two fields, one calculated

Hi,

Please note that the date in the chart of your picture is in a numerical format. Perhapsyou have is one of the two dates presented in the form of a number, the other in the form of a date. Then there will be no association between the tables.

Not applicable

Re: Association two fields, one calculated

How do I check?  They both show as dates in the association window.

dwforest
Valued Contributor

Re: Association two fields, one calculated

Try something like:

Date(Trim(we_date)))