topic Re: pivot table in QlikView https://community.qlik.com/t5/QlikView/pivot-table/m-p/954748#M968816 <HTML><HEAD></HEAD><BODY><P>Try to do this in your set expression.</P><P>If it is static, </P><P>=Sum({&lt;MonthNumber={'&gt;=7'}&gt;}Data)</P></BODY></HTML> Tue, 29 Sep 2015 05:01:55 GMT settu_periasamy 2015-09-29T05:01:55Z pivot table https://community.qlik.com/t5/QlikView/pivot-table/m-p/954746#M968814 <HTML><HEAD></HEAD><BODY><P>hi all , i have the data coming&nbsp; from jan to dec , but i have to show the dta from july in pivot table&nbsp; How?</P></BODY></HTML> Tue, 29 Sep 2015 04:15:09 GMT https://community.qlik.com/t5/QlikView/pivot-table/m-p/954746#M968814 2015-09-29T04:15:09Z Re: pivot table https://community.qlik.com/t5/QlikView/pivot-table/m-p/954747#M968815 <HTML><HEAD></HEAD><BODY><P>Look for Dual function</P><P><A href="https://community.qlik.com/docs/DOC-8106">How to use- Dual()</A></P></BODY></HTML> Tue, 29 Sep 2015 04:53:28 GMT https://community.qlik.com/t5/QlikView/pivot-table/m-p/954747#M968815 robert_mika 2015-09-29T04:53:28Z Re: pivot table https://community.qlik.com/t5/QlikView/pivot-table/m-p/954748#M968816 <HTML><HEAD></HEAD><BODY><P>Try to do this in your set expression.</P><P>If it is static, </P><P>=Sum({&lt;MonthNumber={'&gt;=7'}&gt;}Data)</P></BODY></HTML> Tue, 29 Sep 2015 05:01:55 GMT https://community.qlik.com/t5/QlikView/pivot-table/m-p/954748#M968816 settu_periasamy 2015-09-29T05:01:55Z Re: pivot table https://community.qlik.com/t5/QlikView/pivot-table/m-p/954749#M968817 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=Sum({&lt;MonthID={'&gt;=7'}&gt;}Data)</SPAN></P></BODY></HTML> Tue, 29 Sep 2015 05:03:39 GMT https://community.qlik.com/t5/QlikView/pivot-table/m-p/954749#M968817 gautik92 2015-09-29T05:03:39Z