Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Default Selection in qlikview

Hi

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

Capture.PNG

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

Capture1.PNG

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.

Capture3.PNG

Please help me on this.

Let me know if I am not clear.

Thanks!

14 Replies
lironbaram
Partner - Master III
Partner - Master III

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

qlikmsg4u
Specialist
Specialist

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

Anonymous
Not applicable
Author

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

qlikmsg4u
Specialist
Specialist

See the attached app

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein