Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

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
Partner
Partner

Date Joining failing

Hi

 I have 3 tables  which has order time and extracted date from the same  and trying to join the 3 tables based on date with/With out master calendar but it is not properly joining , what might be the reason, can somebody help me trace where am i Going wrong?

 

Note: used floor , date , formats are same 

 

image.png

 

Regards,

Happiee

Labels (4)
3 Replies
Highlighted
Contributor
Contributor

You can't join these 3 tables just via "date". You need to specify the connections among order amount, past order id, and order No. There has to be a one-to-one relationship, or you will end up with a table like this.
Highlighted
Partner
Partner

Hi,

Unfortunately I do not have any primary key to connect the data sets ,but trying to join them to compare the data sets side by side based on date . so there is no other possibility ?

 

Regards,

imhappiee

Highlighted
Creator
Creator

Hi,

Please check the date field. if it has minits and seconds it is not posible to make joint use flore function to remove the time in the data and make the joint.

hope your format is like :dd-mm-yy hh:mm:ss" make this in to  dd-mm-yy It will work.  🙂