topic Re: Display data according D and D-1 in QlikView https://community.qlik.com/t5/QlikView/Display-data-according-D-and-D-1/m-p/401440#M570867 <HTML><HEAD></HEAD><BODY><P>You might be missing something. Can you attach your applicatino? (just the part that you need for this example)</P></BODY></HTML> Fri, 14 Sep 2012 08:28:30 GMT jvitantonio 2012-09-14T08:28:30Z Display data according D and D-1 https://community.qlik.com/t5/QlikView/Display-data-according-D-and-D-1/m-p/401437#M570864 <HTML><HEAD></HEAD><BODY><P><SPAN id="result_box" lang="en"><SPAN class="hps">I developed</SPAN> <SPAN class="hps">a dynamic array with</SPAN> <SPAN class="hps">two dimensions:</SPAN><BR /> <SPAN class="hps">Site</SPAN> <SPAN class="hps">and date</SPAN><BR /> <SPAN class="hps">plus two</SPAN> <SPAN class="hps">expressions:</SPAN><BR /> <SPAN class="hps">-</SPAN> <SPAN class="hps">The</SPAN> <SPAN class="hps">first</SPAN> <SPAN class="hps">one</SPAN> <SPAN class="hps">calculates</SPAN> <SPAN class="hps">KPI</SPAN> <SPAN class="hps">"PMC"</SPAN> <SPAN class="hps">on the selected date</SPAN><BR /> <SPAN class="hps">- And the other</SPAN> <SPAN class="hps">computes a</SPAN> <SPAN class="hps">KPI</SPAN> <SPAN class="hps">"PMC"</SPAN> <SPAN class="hps">whichever</SPAN> <SPAN class="hps">"selected</SPAN> <SPAN class="hps">day-</SPAN><SPAN class="hps">1"</SPAN><BR /><BR /> <SPAN class="hps">calculates</SPAN> <SPAN class="hps">is</SPAN> <SPAN class="hps">correctly</SPAN> <SPAN class="hps">but the display is</SPAN> <SPAN class="hps">not as good.</SPAN><BR /><BR />what i got<BR /> <SPAN class="hps">Site</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Date</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Ending </SPAN></SPAN><SPAN id="result_box" lang="en"><SPAN class="hps">PMC&nbsp; </SPAN></SPAN><SPAN id="result_box" lang="en"><SPAN class="hps"></SPAN>!&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Begin</SPAN> <SPAN class="hps">PMC</SPAN><BR /> <SPAN class="hps">France&nbsp; </SPAN>&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Total</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">239674&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 239839</SPAN><BR /> <SPAN class="hps">France&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp; </SPAN>&nbsp; </SPAN><SPAN id="result_box" lang="en"><SPAN class="hps">08/23/2012</SPAN></SPAN><SPAN id="result_box" lang="en">&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">239 674&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </SPAN> <SPAN class="hps">0</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <BR /> <SPAN class="hps">France</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp; </SPAN><SPAN id="result_box" lang="en"><SPAN class="hps">08/24/2012 </SPAN></SPAN><SPAN id="result_box" lang="en">&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">0</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">239 839</SPAN> <BR /></SPAN></P><P></P><P></P><P><SPAN id="result_box" lang="en">what I'm looking for</SPAN></P><P></P><P><SPAN id="result_box" lang="en"> <SPAN class="hps">Site</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Date</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Ending </SPAN></SPAN><SPAN id="result_box" lang="en"><SPAN class="hps">PMC&nbsp; </SPAN></SPAN><SPAN id="result_box" lang="en"><SPAN class="hps"></SPAN>!&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Begin</SPAN> <SPAN class="hps">PMC</SPAN><BR /> <SPAN class="hps">France&nbsp; </SPAN>&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">Total</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">239674&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 239839</SPAN></SPAN><SPAN id="result_box" lang="en">&nbsp; <BR /> <SPAN class="hps">France</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp; </SPAN><SPAN id="result_box" lang="en"><SPAN class="hps">08/24/2012 </SPAN></SPAN><SPAN id="result_box" lang="en">&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps"></SPAN></SPAN><SPAN id="result_box" lang="en"><SPAN class="hps">239 674</SPAN></SPAN><SPAN id="result_box" lang="en"><SPAN class="hps"></SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; !&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="hps">239 839</SPAN></SPAN></P><P></P><P></P><P></P><P><SPAN id="result_box" lang="en"><SPAN class="hps">Why is</SPAN> <SPAN class="hps">the date</SPAN> D<SPAN class="hps">-1</SPAN> <SPAN class="hps">is displayed?</SPAN>? <SPAN class="hps">it gives me</SPAN> <SPAN class="hps">0,</SPAN> <SPAN class="hps">for the user</SPAN> <SPAN class="hps">is</SPAN> <SPAN class="hps">false data</SPAN>. I'm looking to display only KPI for the selected date ....!<BR /><BR /><BR /> <SPAN class="hps">what should</SPAN> <SPAN class="hps">I do?</SPAN><BR /><BR /><BR /> <SPAN class="hps">Thank you.</SPAN></SPAN></P></BODY></HTML> Wed, 12 Sep 2012 16:36:36 GMT https://community.qlik.com/t5/QlikView/Display-data-according-D-and-D-1/m-p/401437#M570864 Anonymous 2012-09-12T16:36:36Z Re: Display data according D and D-1 https://community.qlik.com/t5/QlikView/Display-data-according-D-and-D-1/m-p/401438#M570865 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Try like this,</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; =if(<SPAN class="hps" style="font-size: 12px;">calculates</SPAN><SPAN class="hps" style="font-size: 12px;">KPI</SPAN><SPAN class="hps" style="font-size: 12px;">"PMC"</SPAN><SPAN class="hps" style="font-size: 12px;">on the selected date &gt; 0 , </SPAN></P><P><SPAN class="hps" style="font-size: 12px;">calculates</SPAN> <SPAN class="hps" style="font-size: 12px;">KPI</SPAN> <SPAN class="hps" style="font-size: 12px;">"PMC"</SPAN> <SPAN class="hps" style="font-size: 12px;">on the selected date)</SPAN></P><P><SPAN class="hps" style="font-size: 12px;">and for second expression&nbsp; also..<BR /></SPAN></P><P></P><P><SPAN class="hps" style="font-size: 12px;">Hope it helps..<BR /></SPAN></P></BODY></HTML> Wed, 12 Sep 2012 17:00:46 GMT https://community.qlik.com/t5/QlikView/Display-data-according-D-and-D-1/m-p/401438#M570865 MayilVahanan 2012-09-12T17:00:46Z Re: Display data according D and D-1 https://community.qlik.com/t5/QlikView/Display-data-according-D-and-D-1/m-p/401439#M570866 <HTML><HEAD></HEAD><BODY><P>do you know a function like LAG in SQL ?????</P><P></P><P></P><P>in my exemple, idont want to see the line with date = <SPAN id="result_box" lang="en"> </SPAN><SPAN id="result_box" lang="en"><SPAN class="hps">08/23/2012 , beacause i did a selction on </SPAN></SPAN><SPAN id="result_box" lang="en"></SPAN><SPAN id="result_box" lang="en"><SPAN class="hps">08/24/2012</SPAN></SPAN>.</P><P></P><P></P><P>Thx.</P></BODY></HTML> Fri, 14 Sep 2012 08:25:23 GMT https://community.qlik.com/t5/QlikView/Display-data-according-D-and-D-1/m-p/401439#M570866 Anonymous 2012-09-14T08:25:23Z Re: Display data according D and D-1 https://community.qlik.com/t5/QlikView/Display-data-according-D-and-D-1/m-p/401440#M570867 <HTML><HEAD></HEAD><BODY><P>You might be missing something. Can you attach your applicatino? (just the part that you need for this example)</P></BODY></HTML> Fri, 14 Sep 2012 08:28:30 GMT https://community.qlik.com/t5/QlikView/Display-data-according-D-and-D-1/m-p/401440#M570867 jvitantonio 2012-09-14T08:28:30Z