https://community.qlik.com/t5/QlikView/How-to-get-previous-day-data-in-a-data-set/m-p/1154713#M376989 <HTML><HEAD></HEAD><BODY><P>to get the second last you could try with the <STRONG>MAX(Date,2) this will give the second last day </STRONG></P><P><STRONG style="font-size: 13.3333px;">MAX(Date,1) this will give the max date in your data set </STRONG></P><P></P><P>Hope this helps you </P></BODY></HTML> Tue, 23 Aug 2016 12:08:22 GMT avinashelite 2016-08-23T12:08:22Z https://community.qlik.com/t5/QlikView/How-to-get-previous-day-data-in-a-data-set/m-p/1154711#M376987 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I have a serious issue with getting last day production data of my production data set. I need to compare today production qty with last day production qty. It may be yesterday or last day that production department worked. </P><P></P><P>For example, After a vacation period i need to compare the today production data with the day before vacation starts(last production date).</P><P></P><P>Please... help...</P><P></P><P>-- Damitha.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Tue, 23 Aug 2016 10:39:22 GMT https://community.qlik.com/t5/QlikView/How-to-get-previous-day-data-in-a-data-set/m-p/1154711#M376987 2016-08-23T10:39:22Z https://community.qlik.com/t5/QlikView/How-to-get-previous-day-data-in-a-data-set/m-p/1154712#M376988 <HTML><HEAD></HEAD><BODY><P>Hi Damitha,</P><P></P><P>Please check this post : <A href="https://community.qlik.com/thread/85597">How to show yesterday's data by selecting today?</A></P><P></P><P>Set analysis will achieve this for you.</P><P></P><P>Charlie</P></BODY></HTML> Tue, 23 Aug 2016 11:52:05 GMT https://community.qlik.com/t5/QlikView/How-to-get-previous-day-data-in-a-data-set/m-p/1154712#M376988 Anonymous 2016-08-23T11:52:05Z https://community.qlik.com/t5/QlikView/How-to-get-previous-day-data-in-a-data-set/m-p/1154713#M376989 <HTML><HEAD></HEAD><BODY><P>to get the second last you could try with the <STRONG>MAX(Date,2) this will give the second last day </STRONG></P><P><STRONG style="font-size: 13.3333px;">MAX(Date,1) this will give the max date in your data set </STRONG></P><P></P><P>Hope this helps you </P></BODY></HTML> Tue, 23 Aug 2016 12:08:22 GMT https://community.qlik.com/t5/QlikView/How-to-get-previous-day-data-in-a-data-set/m-p/1154713#M376989 avinashelite 2016-08-23T12:08:22Z https://community.qlik.com/t5/QlikView/How-to-get-previous-day-data-in-a-data-set/m-p/1154714#M376990 <HTML><HEAD></HEAD><BODY><P>Keep in mind that your comparison data may be excluded (you have selected today, but want to see values from last week for comparison). In this case, you will have to add set analysis to ignore the current selection in your Max() statement, e.g.</P><P>Max({1} Date,2)</P></BODY></HTML> Tue, 23 Aug 2016 13:44:34 GMT https://community.qlik.com/t5/QlikView/How-to-get-previous-day-data-in-a-data-set/m-p/1154714#M376990 Or 2016-08-23T13:44:34Z https://community.qlik.com/t5/QlikView/How-to-get-previous-day-data-in-a-data-set/m-p/1154715#M376991 <HTML><HEAD></HEAD><BODY><P>This will only get the second newest day of all the days, is it right?</P></BODY></HTML> Wed, 24 Aug 2016 02:51:48 GMT https://community.qlik.com/t5/QlikView/How-to-get-previous-day-data-in-a-data-set/m-p/1154715#M376991 Anonymous 2016-08-24T02:51:48Z https://community.qlik.com/t5/QlikView/How-to-get-previous-day-data-in-a-data-set/m-p/1154716#M376992 <HTML><HEAD></HEAD><BODY><P>try something like this to get previous data:</P><P></P><P></P><P> count({&lt; MonthYear={$(='"'&amp;concat(distinct date(Addmonths</P><P>&nbsp;&nbsp; (MonthYear,-Getselectedcount(MonthYear)) ,'MMM-YYYY') ,'","') &amp;'"')} &gt;} Identifier])</P></BODY></HTML> Wed, 24 Aug 2016 04:08:24 GMT https://community.qlik.com/t5/QlikView/How-to-get-previous-day-data-in-a-data-set/m-p/1154716#M376992 arusanah 2016-08-24T04:08:24Z https://community.qlik.com/t5/QlikView/How-to-get-previous-day-data-in-a-data-set/m-p/1154717#M376993 <HTML><HEAD></HEAD><BODY><P>Hi Avinash,</P><P></P><P>Thank for the prompt reply. I tried with the formula but didn't work...?</P><P>It works for the formula <STRONG>Max(ProductionOutDate,1)</STRONG> but didnt work for fromula <STRONG>Max(ProductionOutDate,2)</STRONG>.</P><P></P><P><IMG __jive_id="135370" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/135370_Capture.PNG" style="height: 314px; width: 620px;" /></P></BODY></HTML> Wed, 24 Aug 2016 05:30:48 GMT https://community.qlik.com/t5/QlikView/How-to-get-previous-day-data-in-a-data-set/m-p/1154717#M376993 2016-08-24T05:30:48Z https://community.qlik.com/t5/QlikView/How-to-get-previous-day-data-in-a-data-set/m-p/1154718#M376994 <HTML><HEAD></HEAD><BODY><P>Try to add a =before the Max() and try again. if your still not able to get the results please share the sample app will check and help&nbsp; you out </P></BODY></HTML> Wed, 24 Aug 2016 07:19:39 GMT https://community.qlik.com/t5/QlikView/How-to-get-previous-day-data-in-a-data-set/m-p/1154718#M376994 avinashelite 2016-08-24T07:19:39Z