topic Need help in set analysis in QlikView https://community.qlik.com/t5/QlikView/Need-help-in-set-analysis/m-p/369724#M137467 <HTML><HEAD></HEAD><BODY><P>Please try this:</P><P></P><P>sum({$&lt;Date = p({$&lt;PrevDate&gt;}Date)&gt;}AMT)</P></BODY></HTML> Thu, 26 Apr 2012 11:04:10 GMT Michiel_QV_Fan 2012-04-26T11:04:10Z Need help in set analysis https://community.qlik.com/t5/QlikView/Need-help-in-set-analysis/m-p/369723#M137466 <HTML><HEAD></HEAD><BODY><P>This the scenario:<BR />i've a table containg columns lets say... </P><P></P><P>DATE&nbsp;&nbsp;&nbsp;&nbsp; Prev DATE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AMT</P><P></P><P>i want a chart displayin two bar graphs:</P><P></P><P>1)&nbsp; AMT for current selection DATE</P><P>2) AMT for DATE=Current selection Prev DATE</P><P></P><P>how can we achive the second expression using set analysis method... ???</P></BODY></HTML> Thu, 26 Apr 2012 10:46:43 GMT https://community.qlik.com/t5/QlikView/Need-help-in-set-analysis/m-p/369723#M137466 2012-04-26T10:46:43Z Need help in set analysis https://community.qlik.com/t5/QlikView/Need-help-in-set-analysis/m-p/369724#M137467 <HTML><HEAD></HEAD><BODY><P>Please try this:</P><P></P><P>sum({$&lt;Date = p({$&lt;PrevDate&gt;}Date)&gt;}AMT)</P></BODY></HTML> Thu, 26 Apr 2012 11:04:10 GMT https://community.qlik.com/t5/QlikView/Need-help-in-set-analysis/m-p/369724#M137467 Michiel_QV_Fan 2012-04-26T11:04:10Z