topic Re: Default Selection in qlikview in QlikView

Default Selection in qlikview

Anonymous — Wed, 08 Jul 2015 06:13:10 GMT

I have two list boxes namely Specialty and Facilities Avalible as shown below,

I have a requirement where if a Speciality is selected say Allergy&Immunolgy, a Facilites Avalible related to Allergy&Immunology must be selected automatically.

So when i select Allergy and Immunolgy i Expect Facilities Avalible to display as

The same should happen for other items in the Specialty list as well.

So if i select Endocrinology and Metabolism, Facilites Avalible related to it must be selected automatically.

Please help me on this.

Let me know if I am not clear.

Thanks!

Re: Default Selection in qlikview

jonathandienst — Wed, 08 Jul 2015 06:20:05 GMT

How would you determine which Facility should be selected when a Specialty is selected?

Re: Default Selection in qlikview

lironbaram — Wed, 08 Jul 2015 06:21:06 GMT

you can use a trigger on the speciality field

and the action will be select possible in facilities field

have a look at the attach example

Re: Default Selection in qlikview

Anonymous — Wed, 08 Jul 2015 06:26:57 GMT

Any of the related facility can be shown selected by default until the user changes it by selecting a Facility of his/her own from Facility listbox.

Re: Default Selection in qlikview

Chanty4u — Wed, 08 Jul 2015 06:31:06 GMT

Hi,

in listbox u have option please find the image

u can use that option for wvry listbox

Thank u

suresh

Re: Default Selection in qlikview

qlikmsg4u — Wed, 08 Jul 2015 06:33:36 GMT

Hi Liron,

In your example I'm unable to change selection to b in F1 listbox, is this a bug?

Re: Default Selection in qlikview

lironbaram — Wed, 08 Jul 2015 06:40:50 GMT

hi check the attach file

the trigger will work properly only with one selected value in the F1

field

Re: Default Selection in qlikview

Anonymous — Wed, 08 Jul 2015 06:41:53 GMT

Thanks for the reply.

I had a look on the application attached by you.

When i select 'a' from F1 list box.

'1,2,3,4' is getting selected in F2 list box.

But my expectation is only one value should be displayed as selected.

It can be any of the F2 values related to F1 selection made.

Re: Default Selection in qlikview

Chanty4u — Wed, 08 Jul 2015 06:45:48 GMT

FOR THAT U CAN USE HIDE EXCLUDED OPTION

thank you

Suresh

Re: Default Selection in qlikview

qlikmsg4u — Wed, 08 Jul 2015 06:47:42 GMT

It only hides the excluded values not the possible values

Re: Default Selection in qlikview

lironbaram — Wed, 08 Jul 2015 06:52:15 GMT

how do you know which value to select from the possible values in F2

Re: Default Selection in qlikview

qlikmsg4u — Wed, 08 Jul 2015 06:56:55 GMT

Sorry Liron, I'm not the thread starter, just I'm asking my doubts

Re: Default Selection in qlikview

Anonymous — Wed, 08 Jul 2015 07:02:09 GMT

We can show of the possible values of F2 related to F1.

Re: Default Selection in qlikview

qlikmsg4u — Wed, 08 Jul 2015 07:05:07 GMT

See the attached app

Re: Default Selection in qlikview

jonathandienst — Wed, 08 Jul 2015 07:17:07 GMT

Koushik G wrote:

Any of the related facility can be shown selected by default until the user changes it by selecting a Facility of his/her own from Facility listbox.

That could be very confusing for your users. Why do you want to do that?

If the reason is that you have an object that takes a long time to calculate unless one one Facility is selected, I suggest using conditional display or conditional calculation instead using a condition like:

=GetPossibleCount([Facilities Available]) = 1