topic Re: Display one year data into charts in QlikView https://community.qlik.com/t5/QlikView/Display-one-year-data-into-charts/m-p/1439440#M818025 <HTML><HEAD></HEAD><BODY><P>You want to display min year or max year's data? May be with set analysis in your expression</P><P></P><P>Max Year</P><P><STRONG>Sum({&lt;Year = {$(=Max(Year))}&gt;}Measure)</STRONG></P><P><STRONG><BR /></STRONG></P><P style="font-size: 13.3333px;">Min Year</P><P style="font-size: 13.3333px;"><STRONG>Sum({&lt;Year = {$(=Min(Year))}&gt;}Measure)</STRONG></P></BODY></HTML> Tue, 05 Sep 2017 16:34:08 GMT sunny_talwar 2017-09-05T16:34:08Z Display one year data into charts https://community.qlik.com/t5/QlikView/Display-one-year-data-into-charts/m-p/1439438#M818023 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>I am using 3 years data into qlikview.</P><P>How&nbsp; to use only one year data into Bar chart.Means "Today()-475 days.</P><P></P><P></P><P></P><P>Thanks</P><P>Gireesh</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Display-one-year-data-into-charts/m-p/1439438#M818023 gireesh1216 2020-11-25T16:16:04Z Re: Display one year data into charts https://community.qlik.com/t5/QlikView/Display-one-year-data-into-charts/m-p/1439439#M818024 <HTML><HEAD></HEAD><BODY><P>Sorry, I do not understand what you want...</P><P>Do you want a chart with a single bar?</P></BODY></HTML> Tue, 05 Sep 2017 16:30:57 GMT https://community.qlik.com/t5/QlikView/Display-one-year-data-into-charts/m-p/1439439#M818024 MarcoARaymundo 2017-09-05T16:30:57Z Re: Display one year data into charts https://community.qlik.com/t5/QlikView/Display-one-year-data-into-charts/m-p/1439440#M818025 <HTML><HEAD></HEAD><BODY><P>You want to display min year or max year's data? May be with set analysis in your expression</P><P></P><P>Max Year</P><P><STRONG>Sum({&lt;Year = {$(=Max(Year))}&gt;}Measure)</STRONG></P><P><STRONG><BR /></STRONG></P><P style="font-size: 13.3333px;">Min Year</P><P style="font-size: 13.3333px;"><STRONG>Sum({&lt;Year = {$(=Min(Year))}&gt;}Measure)</STRONG></P></BODY></HTML> Tue, 05 Sep 2017 16:34:08 GMT https://community.qlik.com/t5/QlikView/Display-one-year-data-into-charts/m-p/1439440#M818025 sunny_talwar 2017-09-05T16:34:08Z Re: Display one year data into charts https://community.qlik.com/t5/QlikView/Display-one-year-data-into-charts/m-p/1439441#M818026 <HTML><HEAD></HEAD><BODY><P>According to your requirement if understand this</P><P><EM style="font-size: 10pt;"><BR /></EM></P><P><EM style="font-size: 10pt;">=Sum( {&lt;DateField = {"$(=Date(Today()-475))"}&nbsp; &gt;} Sales)</EM></P><P></P><P>Or</P><P></P><P><EM style="font-size: 10pt;">=Sum( {&lt;YearField = {"$(=Year(Today()))"}&nbsp; &gt;} Sales)</EM></P><P><EM style="font-size: 10pt;"><BR /></EM></P></BODY></HTML> Tue, 05 Sep 2017 16:58:51 GMT https://community.qlik.com/t5/QlikView/Display-one-year-data-into-charts/m-p/1439441#M818026 its_anandrjs 2017-09-05T16:58:51Z