topic Bar chart Expression in QlikView https://community.qlik.com/t5/QlikView/Bar-chart-Expression/m-p/511508#M191105 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have a bar chart where <STRONG>dimensions : (snapshotdate,salesstage) , expression : sum(amount)</STRONG></P><P>image is attached below....</P><P></P><P>now i want my bar chart to show the next 90 days amount for every snapshotdate....</P><P></P><P>i am trying to use following logic but not getting proper results....</P><P></P><P><STRONG>if(floor(closingdate)&gt;=floor(today()) and&nbsp; num(floor(closingdate))-num(floor(today()))&lt;=90,closingdate)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>how to integrate above logic in bar chart expression to get amount....</STRONG></P></BODY></HTML> Sat, 30 Nov 2013 06:18:06 GMT 2013-11-30T06:18:06Z Bar chart Expression https://community.qlik.com/t5/QlikView/Bar-chart-Expression/m-p/511508#M191105 <HTML><HEAD></HEAD><BODY><P>Hi guys,</P><P></P><P>I have a bar chart where <STRONG>dimensions : (snapshotdate,salesstage) , expression : sum(amount)</STRONG></P><P>image is attached below....</P><P></P><P>now i want my bar chart to show the next 90 days amount for every snapshotdate....</P><P></P><P>i am trying to use following logic but not getting proper results....</P><P></P><P><STRONG>if(floor(closingdate)&gt;=floor(today()) and&nbsp; num(floor(closingdate))-num(floor(today()))&lt;=90,closingdate)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>how to integrate above logic in bar chart expression to get amount....</STRONG></P></BODY></HTML> Sat, 30 Nov 2013 06:18:06 GMT https://community.qlik.com/t5/QlikView/Bar-chart-Expression/m-p/511508#M191105 2013-11-30T06:18:06Z