Re: Date merging - Qlik Community

tenyeapen · ‎2019-11-07

HI,

I have 2 date fields (Created date & transaction date) from 2 data source.

On dashboard I have list box showing month and year, which when I select both the date fields should be affected.

can some one please help......

Victor_Alumanah · ‎2019-11-07

Are you able to post an example? I understand what you mean but it would be useful to see how many fields are in both tables.

While we teach we learn

tenyeapen · ‎2019-11-08

Hi

Both the data sets have more than 15 columns.

tenyeapen · ‎2019-11-10

HI All

please help me in this..

Brett_Bleess · ‎2019-11-12

Have a look at the following Design Blog posts, believe they may help with the use case.

https://community.qlik.com/t5/Qlik-Design-Blog/The-Master-Calendar/ba-p/1471527

https://community.qlik.com/t5/Qlik-Design-Blog/Canonical-Date/ba-p/1463578

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.