topic Re: select a listbox value based on othe other listbox selection in QlikView

select a listbox value based on othe other listbox selection

psankepalli — Wed, 07 Oct 2015 18:48:18 GMT

Hello Experts,

Could you please help me to achieve the below requirement for my project

see the attached file

I have two filters Universe & Dose. Each filter having two list boxes , Universe (Desc 1, Desc1 DET), Dose (Desc 2, Desc2 DET). I want to achieve the below requirement from the attached POC.

Universe	Dose
SUMMARY – TOTAL	SUMMARY – TOTAL
DETAIL – PUBLIC	SUMMARY – TOTAL
DETAIL – PUBLIC & PRIVATE	SUMMARY – TOTAL
DETAIL – PRIVATE	DETAIL – DOSES

Thanks in advance

San

Re: select a listbox value based on othe other listbox selection

ecolomer — Wed, 07 Oct 2015 19:44:24 GMT

See this example

Re: select a listbox value based on othe other listbox selection

psankepalli — Wed, 07 Oct 2015 20:08:09 GMT

Hi Colomer,

Thank you for your reply, but my requirement is I need to select the different value based on the First listbox selection not the same value.

Thanks

San

Re: select a listbox value based on othe other listbox selection

Qrishna — Wed, 07 Oct 2015 20:36:39 GMT

which one one do you want?

Do you want to achieve the table in the grid or

select a listbox value based on othe other listbox selection ?

Re: select a listbox value based on othe other listbox selection

psankepalli — Thu, 08 Oct 2015 11:34:34 GMT

Hi Krishna,

Yes, I want to achive that table. Let me know if you have any other questions

Thanks

San

Re: select a listbox value based on othe other listbox selection

Qrishna — Thu, 08 Oct 2015 15:52:13 GMT

Hi Prasanna,

You may find the script a bit tricky.

But thats one of the way u can choose to achieve the table in the grid as per your requirement.

and make sure you use the data as is which you've provided me in your attachment.

let me know if you find any difficulty.

Thanks

Re: select a listbox value based on othe other listbox selection

psankepalli — Thu, 08 Oct 2015 20:13:51 GMT

Hello Everyone, Thank you for your response.

I am able to achieve my requirement with the help of Triggers.

Here are the steps for reference

Document Settings -> Field Event Triggers -> [Desc 1 DET] On Select

Add Actions -> Add -> Selection -> Select In Field.

Field: [Desc 2]

Search String:

=if(GetFieldSelections([Desc1 DET])='PRIVATE','DETAIL','SUMMARY')

Thanks

San

Re: select a listbox value based on othe other listbox selection

Qrishna — Thu, 08 Oct 2015 20:23:02 GMT

You said you wanted to achieve the table in the grid?

Re: select a listbox value based on othe other listbox selection

psankepalli — Fri, 09 Oct 2015 01:29:08 GMT

Sorry for the confusion caused by me, I want to achive that listbox selection. Thanks you for your response.