topic Help to remove pivots dimensions with set analysis? in QlikView https://community.qlik.com/t5/QlikView/Help-to-remove-pivots-dimensions-with-set-analysis/m-p/888649#M309677 <HTML><HEAD></HEAD><BODY><P>Hello...&nbsp; i have a pivot table (see image attached) and the month-year dimension shows the value of the expression horizontally, as columns.&nbsp;&nbsp; I wanted to integrate a "number of months" slider to display only the month-year columns selected (plus next month)... the columns are still displayed, only the expression values are zero....&nbsp;&nbsp; How can i remove the month-year columns?</P><P></P><P>Expression:</P><P>=sum({&lt;CalendarDate={'&gt;=$(vMaxDate) &lt;=$(vLastDayPrevMonth)'}&gt;} MatPercentage * MonthlyCurrentPrice )</P><P></P><P>Variables:</P><P>vLastDayPrevMonth=MonthEnd(max(CalendarDate))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (sorry variable name not too descriptive)</P><P>vMaxDate=Date(AddMonths(MonthStart(vLastDayPrevMonth),&nbsp; (vRollingMonths * -1)),'DD/MM/YYYY')</P><P></P><P>Any ideas out there in QV land?</P><P></P><P>Thanks in advance,</P><P>Bernard</P></BODY></HTML> Wed, 24 Jun 2015 07:32:27 GMT 2015-06-24T07:32:27Z Help to remove pivots dimensions with set analysis? https://community.qlik.com/t5/QlikView/Help-to-remove-pivots-dimensions-with-set-analysis/m-p/888649#M309677 <HTML><HEAD></HEAD><BODY><P>Hello...&nbsp; i have a pivot table (see image attached) and the month-year dimension shows the value of the expression horizontally, as columns.&nbsp;&nbsp; I wanted to integrate a "number of months" slider to display only the month-year columns selected (plus next month)... the columns are still displayed, only the expression values are zero....&nbsp;&nbsp; How can i remove the month-year columns?</P><P></P><P>Expression:</P><P>=sum({&lt;CalendarDate={'&gt;=$(vMaxDate) &lt;=$(vLastDayPrevMonth)'}&gt;} MatPercentage * MonthlyCurrentPrice )</P><P></P><P>Variables:</P><P>vLastDayPrevMonth=MonthEnd(max(CalendarDate))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (sorry variable name not too descriptive)</P><P>vMaxDate=Date(AddMonths(MonthStart(vLastDayPrevMonth),&nbsp; (vRollingMonths * -1)),'DD/MM/YYYY')</P><P></P><P>Any ideas out there in QV land?</P><P></P><P>Thanks in advance,</P><P>Bernard</P></BODY></HTML> Wed, 24 Jun 2015 07:32:27 GMT https://community.qlik.com/t5/QlikView/Help-to-remove-pivots-dimensions-with-set-analysis/m-p/888649#M309677 2015-06-24T07:32:27Z Re: Help to remove pivots dimensions with set analysis? https://community.qlik.com/t5/QlikView/Help-to-remove-pivots-dimensions-with-set-analysis/m-p/888650#M309678 <HTML><HEAD></HEAD><BODY><P>Nevermind eh!!&nbsp;&nbsp; Solved it myself by upgrading my desktop application to the latest...&nbsp; I love talking to the wall... ;o)</P></BODY></HTML> Fri, 26 Jun 2015 10:11:28 GMT https://community.qlik.com/t5/QlikView/Help-to-remove-pivots-dimensions-with-set-analysis/m-p/888650#M309678 2015-06-26T10:11:28Z