topic Expression in chart question in QlikView https://community.qlik.com/t5/QlikView/Expression-in-chart-question/m-p/567388#M680740 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I'm wondering if a specific bit of logic is achievabe by using expressions. I have fields that represent a date(which is monthly), current balance, and days past due - for each date there are several current balances. For each date I would like to capture the sum of all current balances just on that date that fall within a specific range of days past due, then divide that by the sum of all current balances on that specific date (reguardless of amount of days past due). This will result in a percentage of current balance dollars that fall within a specific date range. I want to graph this in a static way so that if I select a specific date range the graph will not change, and instead just zoom in. Does anyone know if this is possible?</P><P></P><P>Thank you.</P></BODY></HTML> Fri, 11 Apr 2014 21:16:49 GMT 2014-04-11T21:16:49Z Expression in chart question https://community.qlik.com/t5/QlikView/Expression-in-chart-question/m-p/567388#M680740 <HTML><HEAD></HEAD><BODY><P>Hi everyone,</P><P></P><P>I'm wondering if a specific bit of logic is achievabe by using expressions. I have fields that represent a date(which is monthly), current balance, and days past due - for each date there are several current balances. For each date I would like to capture the sum of all current balances just on that date that fall within a specific range of days past due, then divide that by the sum of all current balances on that specific date (reguardless of amount of days past due). This will result in a percentage of current balance dollars that fall within a specific date range. I want to graph this in a static way so that if I select a specific date range the graph will not change, and instead just zoom in. Does anyone know if this is possible?</P><P></P><P>Thank you.</P></BODY></HTML> Fri, 11 Apr 2014 21:16:49 GMT https://community.qlik.com/t5/QlikView/Expression-in-chart-question/m-p/567388#M680740 2014-04-11T21:16:49Z Re: Expression in chart question https://community.qlik.com/t5/QlikView/Expression-in-chart-question/m-p/567389#M680741 <HTML><HEAD></HEAD><BODY><P class="almost_half_cell"><SPAN lang="en"><SPAN class="hps">Hi,<BR /></SPAN></SPAN></P><P class="almost_half_cell"><SPAN lang="en"><SPAN class="hps">Could you</SPAN> <SPAN class="hps">provide a</SPAN> <SPAN class="hps">sketch of</SPAN> <SPAN class="hps">the desired</SPAN> <SPAN class="hps">chart and</SPAN> <SPAN class="hps">sample</SPAN> <SPAN class="hps">data</SPAN> <SPAN class="hps">for example in</SPAN> <SPAN class="hps">excel file</SPAN>?</SPAN></P><P>regards</P><P>Darek</P></BODY></HTML> Fri, 11 Apr 2014 21:40:16 GMT https://community.qlik.com/t5/QlikView/Expression-in-chart-question/m-p/567389#M680741 2014-04-11T21:40:16Z