topic Comparative Analysis: in QlikView https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/677635#M245827 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hello,</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I want to get the variance of current year dayofweek amount and the <SPAN class="pow46f" style="font-weight: bold; font-style: inherit; font-family: inherit; margin: 0 !important; padding: 0 !important; border-bottom-width: 1px !important; text-decoration: underline !important; color: #0000ff !important;">previous year</SPAN> same dayofweek amount...</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Ex:</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">suppose today is 29th Aug 2014 is in 30th week of this year and day of week is Friday..</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">and the <SPAN class="pow46f" style="font-weight: bold; font-style: inherit; font-family: inherit; margin: 0 !important; padding: 0 !important; border-bottom-width: 1px !important; text-decoration: underline !important; color: #0000ff !important;">last</SPAN> year same 30th week Friday fall in 30th Aug 2013. so want to get the variance of these two days..</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">how can i do this&nbsp; at script level..</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Please help me...</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thanks,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Yug.</P></BODY></HTML> Sat, 30 Aug 2014 03:46:22 GMT 2014-08-30T03:46:22Z Comparative Analysis: https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/677635#M245827 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Hello,</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I want to get the variance of current year dayofweek amount and the <SPAN class="pow46f" style="font-weight: bold; font-style: inherit; font-family: inherit; margin: 0 !important; padding: 0 !important; border-bottom-width: 1px !important; text-decoration: underline !important; color: #0000ff !important;">previous year</SPAN> same dayofweek amount...</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Ex:</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">suppose today is 29th Aug 2014 is in 30th week of this year and day of week is Friday..</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">and the <SPAN class="pow46f" style="font-weight: bold; font-style: inherit; font-family: inherit; margin: 0 !important; padding: 0 !important; border-bottom-width: 1px !important; text-decoration: underline !important; color: #0000ff !important;">last</SPAN> year same 30th week Friday fall in 30th Aug 2013. so want to get the variance of these two days..</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">how can i do this&nbsp; at script level..</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Please help me...</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Thanks,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Yug.</P></BODY></HTML> Sat, 30 Aug 2014 03:46:22 GMT https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/677635#M245827 2014-08-30T03:46:22Z