topic pivot table in QlikView https://community.qlik.com/t5/QlikView/pivot-table/m-p/449866#M167883 <HTML><HEAD></HEAD><BODY><P>I am calculating count of orders on dimensions Name and Month. I need only 4 months to display, from Sep to Dec. How can I do this in expression.Thanks</P></BODY></HTML> Wed, 23 Jan 2013 17:57:30 GMT 2013-01-23T17:57:30Z pivot table https://community.qlik.com/t5/QlikView/pivot-table/m-p/449866#M167883 <HTML><HEAD></HEAD><BODY><P>I am calculating count of orders on dimensions Name and Month. I need only 4 months to display, from Sep to Dec. How can I do this in expression.Thanks</P></BODY></HTML> Wed, 23 Jan 2013 17:57:30 GMT https://community.qlik.com/t5/QlikView/pivot-table/m-p/449866#M167883 2013-01-23T17:57:30Z Re: pivot table https://community.qlik.com/t5/QlikView/pivot-table/m-p/449867#M167884 <HTML><HEAD></HEAD><BODY><P>Perhaps you could try something like:</P><P></P><P>count({&lt;month = {"&gt;=Sep &lt;=Dec"}&gt;}Orders)</P><P></P><P>Hope that helps.</P><P></P><P>Matt</P></BODY></HTML> Wed, 23 Jan 2013 18:03:19 GMT https://community.qlik.com/t5/QlikView/pivot-table/m-p/449867#M167884 2013-01-23T18:03:19Z Re: pivot table https://community.qlik.com/t5/QlikView/pivot-table/m-p/449868#M167885 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P>=avg({&lt;[Curative TR Month] = {'Sep','Oct','Nov','Dec'}&gt;}[Curative Turntime]/43200) </P><P></P></BODY></HTML> Wed, 23 Jan 2013 18:25:49 GMT https://community.qlik.com/t5/QlikView/pivot-table/m-p/449868#M167885 2013-01-23T18:25:49Z