Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Bar chart automatically display and hide (conditional) expressions upon system date

Hi,

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 > Today() (System Date), and hidden when there is no arriving shipment on that particular month([Shipmt ETA]).

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?

Shipmt ETA
Shipmt Qty
01/06/201240
11/06/20121200
11/06/2012200
11/06/2012500
11/06/2012500
11/06/201219500
13/06/20122000
13/06/20121000
29/06/201210
28/05/2012100
28/05/2012120
28/05/2012200

Thanks.

Community Browser