topic Expand only current month in pivot in QlikView https://community.qlik.com/t5/QlikView/Expand-only-current-month-in-pivot/m-p/1258333#M397279 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I would like to only have the current month of the pivot expanded by default, and all other months collapsed. This is basically what I'm looking for...I do need the subtotal for the expanded month.</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148078_Capture.PNG" style="height: auto;" /></P><P>Thanks!</P></BODY></HTML> Mon, 02 Jan 2017 13:09:57 GMT 2017-01-02T13:09:57Z Expand only current month in pivot https://community.qlik.com/t5/QlikView/Expand-only-current-month-in-pivot/m-p/1258333#M397279 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I would like to only have the current month of the pivot expanded by default, and all other months collapsed. This is basically what I'm looking for...I do need the subtotal for the expanded month.</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148078_Capture.PNG" style="height: auto;" /></P><P>Thanks!</P></BODY></HTML> Mon, 02 Jan 2017 13:09:57 GMT https://community.qlik.com/t5/QlikView/Expand-only-current-month-in-pivot/m-p/1258333#M397279 2017-01-02T13:09:57Z Re: Expand only current month in pivot https://community.qlik.com/t5/QlikView/Expand-only-current-month-in-pivot/m-p/1258334#M397280 <HTML><HEAD></HEAD><BODY><P>Do you mean this Default</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/148139_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 03 Jan 2017 05:33:30 GMT https://community.qlik.com/t5/QlikView/Expand-only-current-month-in-pivot/m-p/1258334#M397280 Anil_Babu_Samineni 2017-01-03T05:33:30Z Re: Expand only current month in pivot https://community.qlik.com/t5/QlikView/Expand-only-current-month-in-pivot/m-p/1258335#M397281 <HTML><HEAD></HEAD><BODY><P>Sure, however more like the example I provided (month, date, metric)...so if the current month was December it would be at the bottom. And I still need overall total for all rows.</P></BODY></HTML> Thu, 05 Jan 2017 17:40:21 GMT https://community.qlik.com/t5/QlikView/Expand-only-current-month-in-pivot/m-p/1258335#M397281 2017-01-05T17:40:21Z