topic pls help in QlikView

pls help

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

Hi All,

I've 2 list boxes in the attached app.

requirement is I need to restrict the Value(3) in listbox for Country(AUS).

I've tried with below exp

If(GetfieldSelections(Country)='AUS','3',Value)

It seems fine but if I select Value(3) its not giving as I expected.

where I did wrong in my expression??

can some one help me out in this.

Re: pls help

YoussefBelloum — Tue, 18 Sep 2018 13:15:23 GMT

Hi,

what do you mean by: if I select 3 its not giving as I expected. ??

can you explain what is missing?

Re: pls help

satishqlik — Tue, 18 Sep 2018 13:31:48 GMT

It seems find when I used above expression in the Value listbox

But problem with after selections (If I select Value 3 for Country AUS) below snapshot for your reference.

Thanks,

Re: pls help

vishsaggi — Tue, 18 Sep 2018 14:28:10 GMT

May be you want to write same expr for your Country list box like

If(GetfieldSelections(Value) = 3, 'AUS',Country)

Re: pls help

satishqlik — Tue, 18 Sep 2018 14:38:44 GMT

Hi Nagaraju,

Thanks for the response.

I've tried with same in Country list box as well.But still no luck.

I've been facing same problem even if implemented in Country list box.

Can you suggest how to overcome in this??

Re: pls help

vishsaggi — Tue, 18 Sep 2018 14:55:51 GMT

What is the issue you are facing. For me when i select AUS the value shows 3. Then i clear the selections then selected 3 then AUS showed up in Country. Check below:

If this is not what you looking for please elaborate your expected output.

Re: pls help

satishqlik — Tue, 18 Sep 2018 17:49:11 GMT

Apologies for the delay.

You wrote-

"What is the issue you are facing. For me when i select AUS the value shows 3. Then i clear the selections

then selected 3 then AUS showed up in Country."

Here don't clear the selections.

do the below steps:

Select Country AUS in list box.

Now we will be able to see only 3 in other list box(Value)

and select 3 in Value listbox(don't clear the selections)

and see the results as I showed the results in above screenshots.

Also I've tried along with Pick and Match in Value list box in below.

my desired output should be in the below snapshot, it should show only 3 in Value list box.

and after immediate selections in Value list box 3 then it should show(Greyout) corresponding Countries as shown in below.

=If(GetFieldSelections(Country)='AUS',Pick(Match(Value,'3'),Value),Value)

implemented same in other list box(Country) But still no luck.

=If(GetFieldSelections(Value)='3',Pick(Match(Country,'BRZ'),Country),Country)

Please correct me if anything wrong.

Re: pls help

Frank_Hartmann — Tue, 18 Sep 2018 19:22:09 GMT

not sure if this meets your requirement but give it a try.

go to settings --> Document Properties --> Triggers

then go to:

"Field Event Triggers" select Coutry and choose "On Select" -->Add Actions --> Add --> Selection -->Clear Field --> Value

then do the same with Value Field:

"Field Event Triggers" select Value and choose "On Select" -->Add Actions --> Add --> Selection -->Clear Field --> Coutry

Re: pls help

satishqlik — Wed, 19 Sep 2018 02:53:35 GMT

Other than triggers, do we have any alternates to accomplish this because same I need to implement in Qliksense.

Kindly suggest on this