topic Adhoc Reports - How to use set analysis in Expression in QlikView https://community.qlik.com/t5/QlikView/Adhoc-Reports-How-to-use-set-analysis-in-Expression/m-p/558293#M551203 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><P>I have a scenario in which the following set Analysis has to be used in Adhoc Reporting </P><P></P><P>Sum({$&lt;YEAR = {$(=Max(YEAR)-1)}&gt;} VOLUME)</P><P></P><P>I have 2 Table : Dimension , Measures</P><P></P><P>Dimensions are</P><P>CHANNEL</P><P>REGION</P><P>COUNTRY</P><P></P><P></P><P>Measures are</P><P>YTDN-1</P><P>etc</P><P></P><P>How can i add the above set analysis in a way that it works in Expression for Adhoc Reporting?</P><P></P><P></P><P>Thanks</P></BODY></HTML> Thu, 21 Nov 2013 09:12:14 GMT 2013-11-21T09:12:14Z Adhoc Reports - How to use set analysis in Expression https://community.qlik.com/t5/QlikView/Adhoc-Reports-How-to-use-set-analysis-in-Expression/m-p/558293#M551203 <HTML><HEAD></HEAD><BODY><P>Hi All ,</P><P></P><P>I have a scenario in which the following set Analysis has to be used in Adhoc Reporting </P><P></P><P>Sum({$&lt;YEAR = {$(=Max(YEAR)-1)}&gt;} VOLUME)</P><P></P><P>I have 2 Table : Dimension , Measures</P><P></P><P>Dimensions are</P><P>CHANNEL</P><P>REGION</P><P>COUNTRY</P><P></P><P></P><P>Measures are</P><P>YTDN-1</P><P>etc</P><P></P><P>How can i add the above set analysis in a way that it works in Expression for Adhoc Reporting?</P><P></P><P></P><P>Thanks</P></BODY></HTML> Thu, 21 Nov 2013 09:12:14 GMT https://community.qlik.com/t5/QlikView/Adhoc-Reports-How-to-use-set-analysis-in-Expression/m-p/558293#M551203 2013-11-21T09:12:14Z