topic Re: Adhoc Reporting in QlikView https://community.qlik.com/t5/QlikView/Adhoc-Reporting/m-p/816779#M1046907 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>PFA,I&nbsp; thing it help</P></BODY></HTML> Wed, 12 Nov 2014 12:42:29 GMT perumal_41 2014-11-12T12:42:29Z Adhoc Reporting https://community.qlik.com/t5/QlikView/Adhoc-Reporting/m-p/816777#M1046905 <HTML><HEAD></HEAD><BODY><P>i have made a Adhoc report in which i have given <STRONG>Dimension and Measure</STRONG> metrices</P><P><STRONG>Dimension like</STRONG></P><P>year </P><P>month</P><P>quarter</P><P>Customer</P><P>Division</P><P>Country</P><P>city etc</P><P></P><P></P><P>Measure</P><P>Sales</P><P>Collection etc</P><P></P><P></P><P>Now i want to add one more filter for metrices Say SUM, AVG, COUNT etc</P><P></P><P>Example:</P><P>Year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales</P><P>2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000</P><P>2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000</P><P>2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3000</P><P>2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4000</P><P></P><P>Now If any user select say <STRONG>SUM</STRONG> then it should give me following adhoc report:</P><P></P><P>Example:</P><P>Year&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales</P><P>2011&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1000</P><P>2012&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000</P><P>2013&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3000</P><P>2014&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4000</P><P><STRONG>Total SUM&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10000</STRONG></P><P></P><P>Similar for AVG, Count etc</P><P></P><P>Pls suggest.</P></BODY></HTML> Wed, 12 Nov 2014 12:16:42 GMT https://community.qlik.com/t5/QlikView/Adhoc-Reporting/m-p/816777#M1046905 Anonymous 2014-11-12T12:16:42Z Re: Adhoc Reporting https://community.qlik.com/t5/QlikView/Adhoc-Reporting/m-p/816778#M1046906 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>check this</P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-5404">http://community.qlik.com/docs/DOC-5404</A></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Wed, 12 Nov 2014 12:21:38 GMT https://community.qlik.com/t5/QlikView/Adhoc-Reporting/m-p/816778#M1046906 ashfaq_haseeb 2014-11-12T12:21:38Z Re: Adhoc Reporting https://community.qlik.com/t5/QlikView/Adhoc-Reporting/m-p/816779#M1046907 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>PFA,I&nbsp; thing it help</P></BODY></HTML> Wed, 12 Nov 2014 12:42:29 GMT https://community.qlik.com/t5/QlikView/Adhoc-Reporting/m-p/816779#M1046907 perumal_41 2014-11-12T12:42:29Z Re: Adhoc Reporting https://community.qlik.com/t5/QlikView/Adhoc-Reporting/m-p/816780#M1046908 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>see this, hope helps</P><P></P><P>Fernando</P><P></P><P><A href="http://eu-a.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs%2FWhats%20New%20in%20QlikView11.qvw&amp;host=demo11&amp;anonymous=true" title="http://eu-a.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs%2FWhats%20New%20in%20QlikView11.qvw&amp;host=demo11&amp;anonymous=true">QlikView</A></P><P></P><P><A href="http://eu-a.demo.qlik.com/detail.aspx?appName=Whats%20New%20in%20QlikView11.qvw" title="http://eu-a.demo.qlik.com/detail.aspx?appName=Whats%20New%20in%20QlikView11.qvw">Qlik Demos: See QlikView in Action | Demo.Qlik.Com</A></P></BODY></HTML> Wed, 12 Nov 2014 12:45:17 GMT https://community.qlik.com/t5/QlikView/Adhoc-Reporting/m-p/816780#M1046908 fkeuroglian 2014-11-12T12:45:17Z