Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Please let me know any solution for this.
Thanks
Rajneesh
Can you a sample?
Hi
you could add it in script if not exist (just the value 1 or 0 missing) for the field
regards
Hi,
Let say I have a table where Product Information is there with Bit_Value field as below:
Product | Bit_Value | Bit_Value_1 |
Prod_1 | 0 | 1 |
Prod_2 | 0 | 1 |
Prod_3 | 0 | 0 |
Prod_4 | 1 | 0 |
Prod_5 | 0 | 0 |
Prod_6 | 1 | 1 |
Prod_7 | 0 | 1 |
Prod_8 | 0 | 1 |
Prod_9 | 1 | 0 |
Prod_10 | 1 | 0 |
And another inline table :
Test_Result |
Pass |
Fail |
All |
This inline table I am using in list box and I have Field Event trigger written in Document Setting. The trigger is likea;
1. When Pass is selected in list box, show all Product where Bit_Value = 1
2. When Fail is selected in list box, show all product where Bit_Value = 0
3. When All is selected in list box, show all products across Bit_Value
My situation is that I do not have any product in table where Bit_Value = 1. For all product Bit_Value is 0
So ideally when user select Pass from list box, chart should not show any product. But it is displaying all product.
Please help me how can I resolve this issue.
In the same way in another sheet of dashboard based on selection of List box, I need to display Product for different value of Bit_Value_1..
Thanks
Instead of using an inline without any association, can you use an 'IF' condition like if(Bit_Value_1, 'Pass', 'Fail').
Is there a specific reason for using an Inline?
Hi,
Yes. I am using inline table because we have third option ALL . So when user will select ALL from list box, we need to display all products.
But not selecting anything will do the same thing.
Hi,
Yes your are correct that non selection of any thing will work like selection of ALL.
But users need specifically ALL key word. In this case what may be the correct way?
Thanks
The inline Table is used as a List box and based on what he wants to select, he wants to return the bit_value and bit_value1
Hi
add value 0 and 1 in field Bit_Value,
so 1 will be selectable, and no value will be selected in your case :
concatenate (product)
load * inline [Bit_Value
0,
1];
regards