topic Re: List Box values change based on selection in QlikView

List Box values change based on selection

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

Hi Qlik heads,

can you advise me on the below issue?, Issue is I have a table with Group and KPI as fields.

LOAD * Inline [

Group
CL
ED
HV
IE
SB
];
Join
A:
LOAD * Inline [
KPI
To
From
Country
];

whenever I open the application it should show KPIs "From" and "Country" with default selection as From and all the groups. then when I select "CL" in the list of groups, KPI should show "To" and "country" and the group "CL".

Ideally, when I select groups other than "CL", KPI should show From and Country, if the group is "CL" it should show "To" and "Country" , if the previous selection in KPI is "From", upon selection of "CL" group it should show "To" if it is country there shouldn't be any change in KPI selection.

PFA for the sample data.

tresesco‌;stalwar1;swuehl‌

Many thanks in advance!!!

Re: List Box values change based on selection

pooja_prabhu_n — Wed, 25 Jul 2018 08:01:01 GMT

Hi,

you can use field event triggers

settings --> document properties --> trigger -->Field Event Triggers.

Please refer the attached qvw file

Thanks,

Pooja

Re: List Box values change based on selection

Anonymous — Wed, 25 Jul 2018 08:15:13 GMT

Hello Pooja,

Thank you for the response, As I said the KPI list box should always show two values.

Also, always it has to show one selected value based on the conditions I have mentioned in my earlier post

Ideally, when I select groups other than "CL", KPI should show From and Country (it should not select both only one should be selected default is "From"), if the group is "CL" it should show "To" and "Country" , if the previous selection in KPI is "From", upon selection of "CL" group it should show "To" if it is country there shouldn't be any change in KPI selection.

Re: List Box values change based on selection

ahmar811 — Wed, 25 Jul 2018 08:31:49 GMT

please consider below expression in your trigger

=if(Group='CL','("Country"|"To")',if(Group<>'CL','("Country"|"From")'))

I hope this will help you

Regards

Ahmar

Re: List Box values change based on selection

Anonymous — Wed, 25 Jul 2018 09:22:19 GMT

Hello Ahmar,

Thank you for your Response!!

You expression need a slit modification (removed double quotes)

=if(Group='CL','(Country|To)',if(Group<>'CL','(Country|From)'))

Also, my expected result is , when I open the application KPI has to show like

On Open:

when I select Group "CL" KPI has to show

when I return to other Groups it should show

Always the KPI has to show 2 values and one value has to be selected.

Also, when I select Country and group CL it should show

if I select other than "CL" group I should see

in the above two screen shots you can see the change from "To" to "From" when the selection switched to non "CL" group to "CL" from Group.

I hope I have explained my issue bit better than earlier.

Thanks

Re: List Box values change based on selection

ahmar811 — Wed, 25 Jul 2018 09:51:33 GMT

I understand your requirement john.

Go to Seeting->Document Properties

You have to trigger on Document Event Triggers and Field Event Trigger refer below screenshot.

1-Document Event Triggers (OnOpen)

2-Field Event Trigger (On Grop Field)

=if(Group='CL','(Country|To)','(Country|From)')

Regards

Ahmar

Re: List Box values change based on selection

Anonymous — Wed, 25 Jul 2018 10:57:19 GMT

Thank you for your time Ahmar,

I tried the above methods but no luck , KPI object is selecting two values but I need only one value at a time, also KPI should not display 3 values (To, from Country) at any point od time it has to show two values (From, Country) or (To, Country)

Re: List Box values change based on selection

sunny_talwar — Wed, 25 Jul 2018 14:08:54 GMT

Can you check if attached is working for you

Re: List Box values change based on selection

Anonymous — Wed, 25 Jul 2018 14:48:47 GMT

Thank you for looking into this mater Sunny,

it is not working as I expected,

EX: when I clear Group field and try to select Country from KPI I am not able to select it.

Re: List Box values change based on selection

sunny_talwar — Wed, 25 Jul 2018 14:56:54 GMT

With triggers, it always very difficult to get all the things you want... but try now

Re: List Box values change based on selection

Anonymous — Wed, 25 Jul 2018 15:05:09 GMT

Agreed with your comment sunny, but that was the requirement, hence, I am trying to get that . come to your solution. When I select group "CL" and Country "To" I am not able to select it

Thanks for your time!!

Re: List Box values change based on selection

sunny_talwar — Wed, 25 Jul 2018 15:14:09 GMT

Check now

Re: List Box values change based on selection

Anonymous — Wed, 25 Jul 2018 17:42:42 GMT

Bingo!! , its working.

Thank you sunny

Also, Can you let me know how did you restrict list box to show always two values, I have checked the "Triggers" but I didn't get what you did to restrict to 2 values.

Re: List Box values change based on selection

Chanty4u — Wed, 25 Jul 2018 18:39:06 GMT

May be this

=Getselectedcount(fieldname) = 2

in general properties -> calculation condition

Re: List Box values change based on selection

sunny_talwar — Wed, 25 Jul 2018 18:40:29 GMT

Added two list boxes and conditionally hide and show them. Also, used an expression to show two values....

Re: List Box values change based on selection

Anonymous — Thu, 26 Jul 2018 06:50:51 GMT

Thank you for your inputs and time Sunny. have a great day!!