I have a table with a field Bit_Value. This field has value 0 and 1.
In dashboard I have a list box where values are like : X, Y and Z.
Now I have written a field event trigger under document setting that when user will select X from list box, select 1 from Bit_Value field and when user will select Y from list box select 0 from Bit_Value and when user will select Z from list box, clear selection of Bit_Value field.
Now the situation is that this week we have data only where Bit_Value has only 0 and not 1.
In this case when user is selecting X from list box, the chart in dashboard should not show any data as we do not have data in tablw where Bit_Value = 1.
But chart is displaying data where Bit_Value = 0 and in current selection box I can not see any selection in Bit_Value because Bit_Value doesnot have 1.
So is there any way we can force qlikview to display no data when Bit_Value does not have 1.
