topic Re: need help on force selection in QlikView

need help on force selection

musketeers — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: need help on force selection

neelamsaroha157 — Thu, 26 Jul 2018 14:59:10 GMT

Can you a sample?

Re: need help on force selection

ogautier62 — Thu, 26 Jul 2018 15:02:37 GMT

you could add it in script if not exist (just the value 1 or 0 missing) for the field

regards

Re: need help on force selection

musketeers — Thu, 26 Jul 2018 15:10:35 GMT

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

Re: need help on force selection

neelamsaroha157 — Thu, 26 Jul 2018 16:13:21 GMT

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?

Re: need help on force selection

musketeers — Thu, 26 Jul 2018 16:25:45 GMT

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.

Re: need help on force selection

neelamsaroha157 — Thu, 26 Jul 2018 17:04:48 GMT

But not selecting anything will do the same thing.

Re: need help on force selection

musketeers — Thu, 26 Jul 2018 23:48:13 GMT

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

Re: need help on force selection

chris_zitha — Thu, 26 Jul 2018 23:56:44 GMT

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

Re: need help on force selection

ogautier62 — Fri, 27 Jul 2018 06:30:24 GMT

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

1];

regards

Re: need help on force selection

neelamsaroha157 — Fri, 27 Jul 2018 13:37:19 GMT

Does this work for you?