topic Re: Daily Like for Like in a single table ? in QlikView https://community.qlik.com/t5/QlikView/Daily-Like-for-Like-in-a-single-table/m-p/1134411#M372570 <HTML><HEAD></HEAD><BODY><P>Maybe using a DateLink table?</P></BODY></HTML> Tue, 24 May 2016 13:35:48 GMT swuehl 2016-05-24T13:35:48Z Daily Like for Like in a single table ? https://community.qlik.com/t5/QlikView/Daily-Like-for-Like-in-a-single-table/m-p/1134410#M372569 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">Dear all,</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">I have a straight table with a like for like Analysis!! This works well but I need to select one day to achieve the computation.</P><P style="font-size: 13.3333px;">&gt; this is great for a daily report !</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">But now I need to create a monthly daily analysis where all days must be displayed...</P><P style="font-size: 13.3333px;"></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date Like for Like</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Date</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Quantity Previous Year</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Quantity</STRONG></TH></TR><TR><TD style="padding: 2px;">03/01/2015</TD><TD style="padding: 2px;">02/01/2016</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">04/01/2015</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">03/01/2016</SPAN></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR><TR><TD style="padding: 2px;">....</TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">but I my set analysis is not working well!!! =&gt; I have extra rows...</P><P style="font-size: 13.3333px;"><IMG __jive_id="125573" alt="2016-05-24_14h51_44.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125573_2016-05-24_14h51_44.png" /></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">that I want</P><P style="font-size: 13.3333px;"><IMG __jive_id="125574" alt="Result.png" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/125574_Result.png" /></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">In my model I have a dedicated field in the "Master Calendar" to find the N-1 Date , it's Date_LFL.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">The formula for the "Quantity LY" Measure</P><P style="font-size: 13.3333px;">=SUM( {&lt;Date={'$(=Date(max(Date_LFL),'DD/MM/YYYY'))'},Year=,Month=,Day&gt;}Quantity*LFL_TY)</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">thanks in advance for you help.</P></BODY></HTML> Tue, 24 May 2016 13:02:06 GMT https://community.qlik.com/t5/QlikView/Daily-Like-for-Like-in-a-single-table/m-p/1134410#M372569 girard_ben 2016-05-24T13:02:06Z Re: Daily Like for Like in a single table ? https://community.qlik.com/t5/QlikView/Daily-Like-for-Like-in-a-single-table/m-p/1134411#M372570 <HTML><HEAD></HEAD><BODY><P>Maybe using a DateLink table?</P></BODY></HTML> Tue, 24 May 2016 13:35:48 GMT https://community.qlik.com/t5/QlikView/Daily-Like-for-Like-in-a-single-table/m-p/1134411#M372570 swuehl 2016-05-24T13:35:48Z Re: Daily Like for Like in a single table ? https://community.qlik.com/t5/QlikView/Daily-Like-for-Like-in-a-single-table/m-p/1134412#M372571 <HTML><HEAD></HEAD><BODY><P>Hi Swuehl,</P><P></P><P> you've right... I was just looking for this type of Calendar Table...</P><P></P><P>I'll add it very quickly <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P>Thanks a lot four you quick reply</P></BODY></HTML> Tue, 24 May 2016 13:56:52 GMT https://community.qlik.com/t5/QlikView/Daily-Like-for-Like-in-a-single-table/m-p/1134412#M372571 girard_ben 2016-05-24T13:56:52Z