topic Re: How to restrict 3months in pivot table in QlikView https://community.qlik.com/t5/QlikView/How-to-restrict-3months-in-pivot-table/m-p/533760#M1139952 <HTML><HEAD></HEAD><BODY><P>Can you attach your qvw file please? You can get this done easily by using a set analysis in your expression.</P><P>Sum({&lt;Date={"&gt;=....."}, Date={"&lt;=.."}&gt;} Sales)</P></BODY></HTML> Wed, 18 Sep 2013 04:00:00 GMT 2013-09-18T04:00:00Z How to restrict 3months in pivot table https://community.qlik.com/t5/QlikView/How-to-restrict-3months-in-pivot-table/m-p/533759#M1139951 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>I would like to know how to display 3months of a year (Current month and previous 3 months) in the pivot table.</P><P>Can someone help me to get the solution for the same.</P><P></P><P>Thanks and Regards,</P><P>Smitha</P></BODY></HTML> Wed, 18 Sep 2013 03:04:58 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-3months-in-pivot-table/m-p/533759#M1139951 2013-09-18T03:04:58Z Re: How to restrict 3months in pivot table https://community.qlik.com/t5/QlikView/How-to-restrict-3months-in-pivot-table/m-p/533760#M1139952 <HTML><HEAD></HEAD><BODY><P>Can you attach your qvw file please? You can get this done easily by using a set analysis in your expression.</P><P>Sum({&lt;Date={"&gt;=....."}, Date={"&lt;=.."}&gt;} Sales)</P></BODY></HTML> Wed, 18 Sep 2013 04:00:00 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-3months-in-pivot-table/m-p/533760#M1139952 2013-09-18T04:00:00Z Re: Re: How to restrict 3months in pivot table https://community.qlik.com/t5/QlikView/How-to-restrict-3months-in-pivot-table/m-p/533761#M1139953 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>i dont have qvw file. i have to create application still. I have the requirement in xls.please find the xls for your reference.</P><P></P><P>Thanks and Regards,</P><P>Smitha</P></BODY></HTML> Wed, 18 Sep 2013 04:13:23 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-3months-in-pivot-table/m-p/533761#M1139953 2013-09-18T04:13:23Z Re: How to restrict 3months in pivot table https://community.qlik.com/t5/QlikView/How-to-restrict-3months-in-pivot-table/m-p/533762#M1139954 <HTML><HEAD></HEAD><BODY><P>You can have 3 expressions.</P><P></P><P>expression 1</P><P>=sum(if(Month(Transaction_Date)=Month(Today),Metric)</P><P>expression 2</P><P>=sum(if(Month(Transaction_Date)=Month(Today)-1,Metric)</P><P>expression 3</P><P>=sum(if(Month(Transaction_Date)=Month(Today)-2,Metric)</P></BODY></HTML> Wed, 18 Sep 2013 04:27:10 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-3months-in-pivot-table/m-p/533762#M1139954 2013-09-18T04:27:10Z Re: How to restrict 3months in pivot table https://community.qlik.com/t5/QlikView/How-to-restrict-3months-in-pivot-table/m-p/533763#M1139955 <HTML><HEAD></HEAD><BODY><P>See the attached qvw</P></BODY></HTML> Wed, 18 Sep 2013 05:22:58 GMT https://community.qlik.com/t5/QlikView/How-to-restrict-3months-in-pivot-table/m-p/533763#M1139955 er_mohit 2013-09-18T05:22:58Z