topic Re: Limit data in graph to last date in QlikView https://community.qlik.com/t5/QlikView/Limit-data-in-graph-to-last-date/m-p/1288542#M517619 <HTML><HEAD></HEAD><BODY><P>Which other graph? The bar chart?</P></BODY></HTML> Tue, 20 Dec 2016 09:28:56 GMT Gysbert_Wassenaar 2016-12-20T09:28:56Z Limit data in graph to last date https://community.qlik.com/t5/QlikView/Limit-data-in-graph-to-last-date/m-p/1288541#M517618 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>In the enclosed report I have data for around the previous 30 days.</P><P>I have on line graph that should show data for every date.</P><P>The other graph should only show data for the previous day.</P><P>How to do this?</P><P></P><P>/Stefan</P></BODY></HTML> Tue, 20 Dec 2016 09:08:14 GMT https://community.qlik.com/t5/QlikView/Limit-data-in-graph-to-last-date/m-p/1288541#M517618 stekol61 2016-12-20T09:08:14Z Re: Limit data in graph to last date https://community.qlik.com/t5/QlikView/Limit-data-in-graph-to-last-date/m-p/1288542#M517619 <HTML><HEAD></HEAD><BODY><P>Which other graph? The bar chart?</P></BODY></HTML> Tue, 20 Dec 2016 09:28:56 GMT https://community.qlik.com/t5/QlikView/Limit-data-in-graph-to-last-date/m-p/1288542#M517619 Gysbert_Wassenaar 2016-12-20T09:28:56Z Re: Limit data in graph to last date https://community.qlik.com/t5/QlikView/Limit-data-in-graph-to-last-date/m-p/1288543#M517620 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>Yes, the bar chart on Sheet1</P><P></P><P>/Stefan</P></BODY></HTML> Tue, 20 Dec 2016 09:40:29 GMT https://community.qlik.com/t5/QlikView/Limit-data-in-graph-to-last-date/m-p/1288543#M517620 stekol61 2016-12-20T09:40:29Z Re: Limit data in graph to last date https://community.qlik.com/t5/QlikView/Limit-data-in-graph-to-last-date/m-p/1288544#M517621 <HTML><HEAD></HEAD><BODY><P>add the following Set to all your expressions</P><P>Sum ( <SPAN style="text-decoration: underline;">{&lt;Date = {"$(=DATE(Max(Date)-1,'YYYY-MM-DD'))"}&gt;}</SPAN>lat_dis_0_10_ms)</P></BODY></HTML> Tue, 20 Dec 2016 10:04:30 GMT https://community.qlik.com/t5/QlikView/Limit-data-in-graph-to-last-date/m-p/1288544#M517621 vinieme12 2016-12-20T10:04:30Z Re: Limit data in graph to last date https://community.qlik.com/t5/QlikView/Limit-data-in-graph-to-last-date/m-p/1288545#M517622 <HTML><HEAD></HEAD><BODY><P>or use the following calculated Dimension</P><P><STRONG>= if(num(Date) = Max( TOTAL Date)-1 ,Date,null())</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>and check Supress when value is null for this dimension<BR /></STRONG></P></BODY></HTML> Tue, 20 Dec 2016 10:07:17 GMT https://community.qlik.com/t5/QlikView/Limit-data-in-graph-to-last-date/m-p/1288545#M517622 vinieme12 2016-12-20T10:07:17Z Re: Limit data in graph to last date https://community.qlik.com/t5/QlikView/Limit-data-in-graph-to-last-date/m-p/1288546#M517623 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P>This solved the problem.</P><P>Thank You</P><P></P><P>/Stefan</P></BODY></HTML> Tue, 20 Dec 2016 11:19:36 GMT https://community.qlik.com/t5/QlikView/Limit-data-in-graph-to-last-date/m-p/1288546#M517623 stekol61 2016-12-20T11:19:36Z