topic Re: Show list box value by Select Condition in QlikView

Show list box value by Select Condition

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

Hi,

I have a question, i have two list box object.

the first one has two value (Select A, Select B), the second one has three value (A with flag Y, B with flag N, C with Flag Y)

When i choose Select A on the first list box, i want to show only A and C (value with Y flag) on the second list box. And when i choose Select B i want to show all values on the second list box.

I have try using this expression on the second list box -->

=if(GetFieldSelections(Selections)='Select A',

Only({<Flag={'Y'}>}Value), Value

)

But it is not working and not showing any value.

Anybody has idea ?

i also attach my sample file here.

Thanks in advance.

Re: Show list box value by Select Condition

tamilarasu — Tue, 03 May 2016 04:39:37 GMT

Lejours,

Try below expression,

=if(GetFieldSelections(Selections)='Select A',

Aggr(Only({<Flag={'Y'}>}Value),Value), Value

)

Re: Show list box value by Select Condition

Anonymous — Tue, 03 May 2016 04:45:38 GMT

Hi Tamil,

Thanks for your idea.

But i found some problem:

The first one is, when I choose Select A , then i choose A on the second list box, the C value is missing from the second list box.
The second one is, when I choose Select B, then i choose A on the second list box, the Select A in first list box is also choosed.

Do you know how to solve it ?

Thanks in advance.

Re: Show list box value by Select Condition

ajsjoshua — Tue, 03 May 2016 04:55:45 GMT

Hi,

Its working

PFA

Re: Show list box value by Select Condition

ajsjoshua — Tue, 03 May 2016 04:56:19 GMT

Hi,

use this exp

=if(GetFieldSelections(Selections)='Select A',

Aggr(Only({<Flag={'Y'}>}Value),Value), Aggr(Only({<Flag={'N'}>}Value),Value)

)

Re: Show list box value by Select Condition

tamilarasu — Tue, 03 May 2016 05:25:21 GMT

I will check.

Re: Show list box value by Select Condition

Kushal_Chawda — Tue, 03 May 2016 05:52:58 GMT

Can you try something like this

Associate your Select A and Select B values to your data like below

Selection:

LOAD * inline [

Selections, Flag

Select A, Y

Select B, Y

Select B, N ];

Now link this table on Flag. So when you will do 'Select A' Values associated with Flag Y will be displayed and when you do 'Select B' Values associated with both Y & N will be displayed

Re: Show list box value by Select Condition

sunny_talwar — Tue, 03 May 2016 08:52:25 GMT

This:

=if(GetFieldSelections(Selections)='Select A',

Aggr(Only({1<Flag={'Y'}>}Value),Value), Value)

Re: Show list box value by Select Condition

Anonymous — Tue, 03 May 2016 09:05:47 GMT

Hi Sunny,

Thanks for the idea, but i found another problem.

When i choose Select B from the first list box and then i choose A from the second listbox, "Select A" on the first list box also choosed automatically.

Here is the illustration:

second problem is when i choose Select A and then choose A from the second list box, and i click A again in order to clear the selection in the second list box, the selection in the first list box also cleared.

Do you know how to fix it ?

Really appreciate your help.

Thanks in advance.

Re: Show list box value by Select Condition

Anonymous — Tue, 03 May 2016 09:26:07 GMT

Hi Kushal,

Thanks for the idea.

I've try this method, but i found some problem that doesn't meet my requirement.

The problem is, when i choose Select B, only the value with FLAG N can be choosed. But another value with flag Y also shown. Is it possible to hide the Value from the list box ?

Thanks in advance.

Re: Show list box value by Select Condition

Tue, 03 May 2016 11:08:20 GMT

Hi Lejour,

Please check this.

definitely Working.

Re: Show list box value by Select Condition

Anonymous — Tue, 03 May 2016 11:25:17 GMT

I think that cant be done. Because in all d way. Select A is associated with A,C and Select B is associated with respective. So if you select or clear any one of them, the other will respond as per the association we have made in the expression.

Re: Show list box value by Select Condition

qliksus — Wed, 04 May 2016 10:15:22 GMT

Hi ,

This is kind of indirect method just check and let me know if this works