Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
rish
Contributor III
Contributor III

association with Multiple date fields in the same table

I have associated a few date fields from different tables to a single column table which only stores date. Whenever I try to filter data according a date from one of these associated date fields, all the visualizations change except for a table sheet i have put up on the dashboard. The data doesnt get filtered according to the selections i have made, but all the dates in the date field are changed to the date i picked. I have given an example below:

say column a has 3 values: 01/01/2019,01/02/2019,01/03/2019

If I pick only one these values, the table should return only one row associated with it, but it returns 3 rows with the same date.

It would be great if you could guide me in how to tackle this issue, thanks. 🙂

 

5 Replies
eduardo_dimperio
Specialist II
Specialist II

Hi Rish, did you see if the all tables are linked?

rish
Contributor III
Contributor III
Author

Yes i linked them manually as per the date fields

eduardo_dimperio
Specialist II
Specialist II

Could you please share your code just to check how you linked?

rish
Contributor III
Contributor III
Author

Hi, Sorry i am new to qlik sense, I dont know where to find this code. Could you please guide me? I just linked them by dragging two data bubbles onto each other Qlik Sense Data manager and Associated them even though the platform is suggesting that they dont really match. All the visualizations are working fine but I am having issues with tables only.

eduardo_dimperio
Specialist II
Specialist II

Ahhhh, got it

Try find the code area like in this jpg(I painted yeallow to make it easier). 

image.png