Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

pls help

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.

Tags (1)
8 Replies
Highlighted
Champion
Champion

Re: pls help

Hi,

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

can you explain what is missing?

Highlighted
Creator II
Creator II

Re: pls help

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

Capt1.JPG

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

Capt2.JPG

Thanks,

Highlighted
Champion III
Champion III

Re: pls help

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

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

Highlighted
Creator II
Creator II

Re: pls help

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??

Highlighted
Champion III
Champion III

Re: pls help

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:

Capture.PNG

Capture1.PNG

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

Highlighted
Creator II
Creator II

Re: pls help

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.  


op1.JPG


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

op2.JPG


=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.



Highlighted
Master II
Master II

Re: pls help

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

Highlighted
Creator II
Creator II

Re: pls help

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

Kindly suggest on this