https://community.qlik.com/t5/QlikView/How-to-show-yesterday-s-data-by-selecting-today/m-p/518018#M483532 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I'm trying to show a comparison between a previous data&nbsp; and today's data in qv. However I'm stuck because I don't know what to do so qlikview can show me today and yesterdays information by selecting today. </P><P></P><P>Let me explain you, I have data everyday for the last 3 years, and I neeed to see everyday how was my number 2 days ago and how is it today, in order to see if I improved or not from what happened 2 days ago.&nbsp; Therefore I want to select in qv today, and to show me in one column today's information and in another 2 days ago information. I want it to show me 2 days ago information always. No matter if I select 2 months, I want to know the number of those 2 months in one column and in the other the information of 2 days ago. </P><P></P><P>Does anyone know how to do it?</P></BODY></HTML> Thu, 27 Jun 2013 17:57:23 GMT 2013-06-27T17:57:23Z https://community.qlik.com/t5/QlikView/How-to-show-yesterday-s-data-by-selecting-today/m-p/518018#M483532 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I'm trying to show a comparison between a previous data&nbsp; and today's data in qv. However I'm stuck because I don't know what to do so qlikview can show me today and yesterdays information by selecting today. </P><P></P><P>Let me explain you, I have data everyday for the last 3 years, and I neeed to see everyday how was my number 2 days ago and how is it today, in order to see if I improved or not from what happened 2 days ago.&nbsp; Therefore I want to select in qv today, and to show me in one column today's information and in another 2 days ago information. I want it to show me 2 days ago information always. No matter if I select 2 months, I want to know the number of those 2 months in one column and in the other the information of 2 days ago. </P><P></P><P>Does anyone know how to do it?</P></BODY></HTML> Thu, 27 Jun 2013 17:57:23 GMT https://community.qlik.com/t5/QlikView/How-to-show-yesterday-s-data-by-selecting-today/m-p/518018#M483532 2013-06-27T17:57:23Z https://community.qlik.com/t5/QlikView/How-to-show-yesterday-s-data-by-selecting-today/m-p/518019#M483533 <HTML><HEAD></HEAD><BODY><P>You can use set analysis to accomplish this. What you will need to know is what "today" constitutes to determine yesterday.</P><P></P><P>Does "today" mean the actual current day, regardless of the data model? In that case, you could create a variable for yesterday like so:</P><P></P><P>vYesterday:<EM> =today()-1</EM></P><P></P><P>This will be in numeric format. If you need it as a date string, you can wrap it in date():</P><P></P><P>vYesterday:<EM> =date(today()-1)</EM></P><P></P><P>Alternatively, "today" might just mean the most recent date available in your data or subset of data selected. To calculate this, you will need to take the max of your date field:</P><P></P><P>vYesterday: <EM>=max([DateField])-1</EM></P><P>or</P><P>vYesterday:<EM> =date(max([DateField])-1)</EM></P><P></P><P>Now that you have determined the correct day and stored it in a variable, you can use set analysis in the expression you want to limit to yesterday. The expression would look like this:</P><P></P><P><EM>sum({&lt;[DateField]={'$(vYesterday)'}&gt;} Expression1)</EM></P><P></P><P>What this does it tell QlikView to calculate the sum of Expression1 where your DateField is equal to the value stored in vYesterday.</P></BODY></HTML> Thu, 27 Jun 2013 19:15:23 GMT https://community.qlik.com/t5/QlikView/How-to-show-yesterday-s-data-by-selecting-today/m-p/518019#M483533 skokenes 2013-06-27T19:15:23Z