topic Re: Dates. in QlikView https://community.qlik.com/t5/QlikView/Dates/m-p/607548#M1104763 <HTML><HEAD></HEAD><BODY><P>If you could give us your sample file would be helpful to redirect you in proper direction.</P></BODY></HTML> Fri, 21 Mar 2014 11:56:38 GMT MK_QSL 2014-03-21T11:56:38Z Dates. https://community.qlik.com/t5/QlikView/Dates/m-p/607547#M1104762 <HTML><HEAD></HEAD><BODY><P style="color: #222222; font-family: arial, sans-serif;">Hi Friends</P><P style="color: #222222; font-family: arial, sans-serif;">I have a chart that contain 3 columns..</P><P style="color: #222222; font-family: arial, sans-serif;">1.Fisicalweek--Calender Table(dimension)</P><P style="color: #222222; font-family: arial, sans-serif;">2.OrderDate--Header Fact Table</P><P style="color: #222222; font-family: arial, sans-serif;">3.Shippeddate-Header Fact Table</P><P style="color: #222222; font-family: arial, sans-serif;"></P><P style="color: #222222; font-family: arial, sans-serif;">In this There is a Association between Calender and Header Fact Table.</P><P style="color: #222222; font-family: arial, sans-serif;"></P><P style="color: #222222; font-family: arial, sans-serif;">The main thing is I want to find the Total no of "OrderDates" Per week and Total no "ShippedDates" Per week .. These two are Date Fields</P><P style="color: #222222; font-family: arial, sans-serif;"></P><P style="color: #222222; font-family: arial, sans-serif;">I am getting Total No Of "OrderDates" Per week By using Count(OrderDate) . if i apply the same thing for delivery date </P><P style="color: #222222; font-family: arial, sans-serif;"></P><P style="color: #222222; font-family: arial, sans-serif;">But i am not getting Total no "ShippedDates" Perweek.</P><P style="color: #222222; font-family: arial, sans-serif;"></P><P style="color: #222222; font-family: arial, sans-serif;">So Could you please help me how to find the Total no "ShippedDates" Per week.</P><P style="color: #222222; font-family: arial, sans-serif;"></P><P style="color: #222222; font-family: arial, sans-serif;">I was trying this using set analysis but i am not getting the exact result.</P><P style="color: #222222; font-family: arial, sans-serif;"></P><P style="color: #222222; font-family: arial, sans-serif;">Thanks&amp;Regards</P></BODY></HTML> Fri, 21 Mar 2014 11:50:00 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/607547#M1104762 2014-03-21T11:50:00Z Re: Dates. https://community.qlik.com/t5/QlikView/Dates/m-p/607548#M1104763 <HTML><HEAD></HEAD><BODY><P>If you could give us your sample file would be helpful to redirect you in proper direction.</P></BODY></HTML> Fri, 21 Mar 2014 11:56:38 GMT https://community.qlik.com/t5/QlikView/Dates/m-p/607548#M1104763 MK_QSL 2014-03-21T11:56:38Z