topic Bar chart automatically display and hide (conditional) expressions upon system date in QlikView https://community.qlik.com/t5/QlikView/Bar-chart-automatically-display-and-hide-conditional-expressions/m-p/372436#M1174428 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have data as below. I have expressed the arriving shipment quantities by future shipment arriving dates (converted in months), in the waterfall chart. I would like to set conditions for each of the expression, to be displayed the respectively when the corresponding arriving shipment date ([Shipmt ETA]) is &gt; Today() (System Date), and hidden when there is no arriving shipment on that particular month([Shipmt ETA]).</P><P></P><P>How should I set the conditions to let the expressions to be displayed and hidden automatically, without using any action in button or text object?</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="313" style="border: 1px solid rgb(0, 0, 0); width: 194px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Shipmt ETA</STRONG><BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Shipmt Qty</STRONG><BR /></TH></TR><TR><TD>01/06/2012</TD><TD>40</TD></TR><TR><TD>11/06/2012</TD><TD>1200</TD></TR><TR><TD>11/06/2012</TD><TD>200</TD></TR><TR><TD>11/06/2012</TD><TD>500</TD></TR><TR><TD>11/06/2012</TD><TD>500</TD></TR><TR><TD>11/06/2012</TD><TD>19500</TD></TR><TR><TD>13/06/2012</TD><TD>2000</TD></TR><TR><TD>13/06/2012</TD><TD>1000</TD></TR><TR><TD>29/06/2012</TD><TD>10</TD></TR><TR><TD>28/05/2012</TD><TD>100</TD></TR><TR><TD>28/05/2012</TD><TD>120</TD></TR><TR><TD>28/05/2012</TD><TD>200</TD></TR></TBODY></TABLE><P></P><P>Thanks.</P></BODY></HTML> Thu, 28 Jun 2012 09:14:18 GMT 2012-06-28T09:14:18Z Bar chart automatically display and hide (conditional) expressions upon system date https://community.qlik.com/t5/QlikView/Bar-chart-automatically-display-and-hide-conditional-expressions/m-p/372436#M1174428 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have data as below. I have expressed the arriving shipment quantities by future shipment arriving dates (converted in months), in the waterfall chart. I would like to set conditions for each of the expression, to be displayed the respectively when the corresponding arriving shipment date ([Shipmt ETA]) is &gt; Today() (System Date), and hidden when there is no arriving shipment on that particular month([Shipmt ETA]).</P><P></P><P>How should I set the conditions to let the expressions to be displayed and hidden automatically, without using any action in button or text object?</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="313" style="border: 1px solid rgb(0, 0, 0); width: 194px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Shipmt ETA</STRONG><BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><STRONG>Shipmt Qty</STRONG><BR /></TH></TR><TR><TD>01/06/2012</TD><TD>40</TD></TR><TR><TD>11/06/2012</TD><TD>1200</TD></TR><TR><TD>11/06/2012</TD><TD>200</TD></TR><TR><TD>11/06/2012</TD><TD>500</TD></TR><TR><TD>11/06/2012</TD><TD>500</TD></TR><TR><TD>11/06/2012</TD><TD>19500</TD></TR><TR><TD>13/06/2012</TD><TD>2000</TD></TR><TR><TD>13/06/2012</TD><TD>1000</TD></TR><TR><TD>29/06/2012</TD><TD>10</TD></TR><TR><TD>28/05/2012</TD><TD>100</TD></TR><TR><TD>28/05/2012</TD><TD>120</TD></TR><TR><TD>28/05/2012</TD><TD>200</TD></TR></TBODY></TABLE><P></P><P>Thanks.</P></BODY></HTML> Thu, 28 Jun 2012 09:14:18 GMT https://community.qlik.com/t5/QlikView/Bar-chart-automatically-display-and-hide-conditional-expressions/m-p/372436#M1174428 2012-06-28T09:14:18Z