topic Re: How can I sort data on two date basis? in QlikView https://community.qlik.com/t5/QlikView/How-can-I-sort-data-on-two-date-basis/m-p/555182#M207383 <HTML><HEAD></HEAD><BODY><P>Hi narkamol,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; If I understood your question correctly, your trying to sort the dates in your generated report based on the selection of the master Calender date.</P><P></P><P>To do so, you should link the tables together using Synthetic key. What I mean by these is that, whenever a selection on the Calender date is done, the report automatically generates a report based on the selection and the invoice dates.</P><P></P><P>Hope this explanation helps you out!</P><P></P><P>Best Regards,</P><P>Ram</P></BODY></HTML> Mon, 05 Aug 2013 02:05:28 GMT 2013-08-05T02:05:28Z How can I sort data on two date basis? https://community.qlik.com/t5/QlikView/How-can-I-sort-data-on-two-date-basis/m-p/555181#M207382 <HTML><HEAD></HEAD><BODY><P>How can I sort data on two date basis?</P><P>If I select Calendar date then data sort by invoice date,doc date(using filter option for invoice date,doc date)</P></BODY></HTML> Sat, 03 Aug 2013 04:56:16 GMT https://community.qlik.com/t5/QlikView/How-can-I-sort-data-on-two-date-basis/m-p/555181#M207382 2013-08-03T04:56:16Z Re: How can I sort data on two date basis? https://community.qlik.com/t5/QlikView/How-can-I-sort-data-on-two-date-basis/m-p/555182#M207383 <HTML><HEAD></HEAD><BODY><P>Hi narkamol,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; If I understood your question correctly, your trying to sort the dates in your generated report based on the selection of the master Calender date.</P><P></P><P>To do so, you should link the tables together using Synthetic key. What I mean by these is that, whenever a selection on the Calender date is done, the report automatically generates a report based on the selection and the invoice dates.</P><P></P><P>Hope this explanation helps you out!</P><P></P><P>Best Regards,</P><P>Ram</P></BODY></HTML> Mon, 05 Aug 2013 02:05:28 GMT https://community.qlik.com/t5/QlikView/How-can-I-sort-data-on-two-date-basis/m-p/555182#M207383 2013-08-05T02:05:28Z