Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Master
Master

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.

Highlighted
Not applicable

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

Highlighted
Specialist II
Specialist II

Try something like:

Date(Trim(we_date)))