topic Show values for months not selected in QlikView https://community.qlik.com/t5/QlikView/Show-values-for-months-not-selected/m-p/111562#M17353 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>How do I write an expression in a pivot table that shows the values that are not selected by a list box/current selection for a certain dimension:</P><P></P><P>For example:</P><P></P><P>I choose months 1-3, I need the expression to show months 4-12.</P><P></P><P>Is that possible?</P><P></P><P>Many thanks.</P><P></P><P>Best regards,</P><P>Jan</P></BODY></HTML> Tue, 06 Nov 2018 14:05:51 GMT schumi1980 2018-11-06T14:05:51Z Show values for months not selected https://community.qlik.com/t5/QlikView/Show-values-for-months-not-selected/m-p/111562#M17353 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P>How do I write an expression in a pivot table that shows the values that are not selected by a list box/current selection for a certain dimension:</P><P></P><P>For example:</P><P></P><P>I choose months 1-3, I need the expression to show months 4-12.</P><P></P><P>Is that possible?</P><P></P><P>Many thanks.</P><P></P><P>Best regards,</P><P>Jan</P></BODY></HTML> Tue, 06 Nov 2018 14:05:51 GMT https://community.qlik.com/t5/QlikView/Show-values-for-months-not-selected/m-p/111562#M17353 schumi1980 2018-11-06T14:05:51Z Re: Show values for months not selected https://community.qlik.com/t5/QlikView/Show-values-for-months-not-selected/m-p/111563#M17354 <HTML><HEAD></HEAD><BODY><P>You could use something like this: sum({&lt; Month = e(Month) &gt;} VALUE)</P><P></P><P>- Marcus</P></BODY></HTML> Tue, 06 Nov 2018 14:13:32 GMT https://community.qlik.com/t5/QlikView/Show-values-for-months-not-selected/m-p/111563#M17354 marcus_sommer 2018-11-06T14:13:32Z