topic Show/Hide Pivot Table Column By Selected Months in QlikView https://community.qlik.com/t5/QlikView/Show-Hide-Pivot-Table-Column-By-Selected-Months/m-p/488938#M482416 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>May I know how to show/hide columns of following table when selecting different months?</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="border: 1px solid #000000;"><TBODY><TR><TH align="center" colspan="2" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Feb-13</STRONG></SPAN></TH><TH align="center" colspan="2" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Mar-13</STRONG></SPAN></TH><TH align="center" colspan="2" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Apr-13</STRONG></SPAN></TH></TR><TR><TD>ColA</TD><TD>ColB</TD><TD>ColA</TD><TD>ColB</TD><TD>ColA</TD><TD>ColB</TD></TR><TR><TD>10</TD><TD>20</TD><TD>30</TD><TD>40</TD><TD>25</TD><TD>35</TD></TR></TBODY></TABLE><P></P><P>So, when I select Mar-13, it would only show Feb-13 and Apr-13. Please help and advise. Thank you.</P></BODY></HTML> Tue, 13 Aug 2013 11:03:03 GMT 2013-08-13T11:03:03Z Show/Hide Pivot Table Column By Selected Months https://community.qlik.com/t5/QlikView/Show-Hide-Pivot-Table-Column-By-Selected-Months/m-p/488938#M482416 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>May I know how to show/hide columns of following table when selecting different months?</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="border: 1px solid #000000;"><TBODY><TR><TH align="center" colspan="2" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Feb-13</STRONG></SPAN></TH><TH align="center" colspan="2" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Mar-13</STRONG></SPAN></TH><TH align="center" colspan="2" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Apr-13</STRONG></SPAN></TH></TR><TR><TD>ColA</TD><TD>ColB</TD><TD>ColA</TD><TD>ColB</TD><TD>ColA</TD><TD>ColB</TD></TR><TR><TD>10</TD><TD>20</TD><TD>30</TD><TD>40</TD><TD>25</TD><TD>35</TD></TR></TBODY></TABLE><P></P><P>So, when I select Mar-13, it would only show Feb-13 and Apr-13. Please help and advise. Thank you.</P></BODY></HTML> Tue, 13 Aug 2013 11:03:03 GMT https://community.qlik.com/t5/QlikView/Show-Hide-Pivot-Table-Column-By-Selected-Months/m-p/488938#M482416 2013-08-13T11:03:03Z Re: Show/Hide Pivot Table Column By Selected Months https://community.qlik.com/t5/QlikView/Show-Hide-Pivot-Table-Column-By-Selected-Months/m-p/488939#M482417 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Expression -&gt; In conditional expression -&gt; </P><P></P><P>GetFieldSelection(Month) &lt;&gt; 'Mar-13' for mar-13 expression</P></BODY></HTML> Tue, 13 Aug 2013 11:10:34 GMT https://community.qlik.com/t5/QlikView/Show-Hide-Pivot-Table-Column-By-Selected-Months/m-p/488939#M482417 MayilVahanan 2013-08-13T11:10:34Z