topic Re: Villkor i diagram in QlikView https://community.qlik.com/t5/QlikView/Villkor-i-diagram/m-p/737587#M541029 <HTML><HEAD></HEAD><BODY><P>You can do that using set analysis. For example sum(Amount) could become something like:</P><P>sum({&lt;MyDate={'&gt;=$(=num(monthstart( max(MyDate),-1)))&lt;=$(=num(monthend(max(MyDate),-1)))'}&gt;}Amount)</P></BODY></HTML> Wed, 09 Jul 2014 11:56:29 GMT Gysbert_Wassenaar 2014-07-09T11:56:29Z Villkor i diagram https://community.qlik.com/t5/QlikView/Villkor-i-diagram/m-p/737586#M541028 <HTML><HEAD></HEAD><BODY><P><SPAN><SPAN>Hur kan jag Lagga ett villkor till ett stapeldiagram så att jag t ex bara ser uppgifter från den senaste månaden?</SPAN></SPAN></P><P><SPAN><SPAN>- Lars</SPAN></SPAN></P></BODY></HTML> Wed, 09 Jul 2014 07:29:57 GMT https://community.qlik.com/t5/QlikView/Villkor-i-diagram/m-p/737586#M541028 2014-07-09T07:29:57Z Re: Villkor i diagram https://community.qlik.com/t5/QlikView/Villkor-i-diagram/m-p/737587#M541029 <HTML><HEAD></HEAD><BODY><P>You can do that using set analysis. For example sum(Amount) could become something like:</P><P>sum({&lt;MyDate={'&gt;=$(=num(monthstart( max(MyDate),-1)))&lt;=$(=num(monthend(max(MyDate),-1)))'}&gt;}Amount)</P></BODY></HTML> Wed, 09 Jul 2014 11:56:29 GMT https://community.qlik.com/t5/QlikView/Villkor-i-diagram/m-p/737587#M541029 Gysbert_Wassenaar 2014-07-09T11:56:29Z