topic how to select values from a field using other field in QlikView

how to select values from a field using other field

sushil353 — Wed, 05 Oct 2011 05:16:38 GMT

Hi All,

I am having 3 fields named as OP_VERNUM, PRD_OP_VERNUM and YIELD VERSION as shown in fig..

I want to make selections in OP_VERNUM fiels whenever i select values from YIELD VERSION field.. such as

if i select "show first pass data" then 1 should be selected from OP_VERNUM and PRD_OP_VERNUM FIELDS

if "show second pass data" is selected then 2 should be selected from OP_VERNUM and PRD_OP_VERNUM FIELDS

if "show third pass" is selected then 3 should be selected from OP_VERNUM and PRD_OP_VERNUM FIELDS

and if " show all" is selected then all values all values from OP_VERNUM and PRD_OP_VERNUM FIELDS should be selected

Please help me to solve this problem.. i am using qlikview 10. Yield version field have no link with other tables it is loaded using load inline

Thanks

sushil kumar

how to select values from a field using other field

martinpedersen — Wed, 05 Oct 2011 06:37:16 GMT

Depending of which Qlikview version you have, you could use triggers? Go to sheet properties -> Triggers -> Select listbox in "sheet object event triggers" -> press add actions -> define the actions.

I think you must have QV 9 and above to use triggers?

how to select values from a field using other field

martinpedersen — Wed, 05 Oct 2011 06:38:23 GMT

I see you use QV10 - then you can use triggers

how to select values from a field using other field

sushil353 — Wed, 05 Oct 2011 06:46:33 GMT

Thanks Martin,

According to your solution, the selections can be made to active or deactive objects...

I want triggers of field data... like trigger when "show first pass data" is selected

Thanks

how to select values from a field using other field

martinpedersen — Wed, 05 Oct 2011 07:11:19 GMT

You will need to add actions to both OnActivate and OnDeactivate - it is the action that will be performed when you select and item in the list box. So you will have to add an action to when you select and item and to when you deselect and item.

You can use the action "Select in Field" where the field is OP_VERNUM etc. And the expression should evaluate the selection in OP_VERNUM based on you selection in Yield Version?

Its not the most pretty solution but it will do the trick

Re: how to select values from a field using other field

llauses243 — Wed, 05 Oct 2011 08:23:00 GMT

Hi,

There are 2 cases, then 2 solutions

1.- A field (to select) with other relationed (to change as possible), in general different values

2.- 2 fields unrelationed, in general with equal values, here i use button & variable

Adjust both solutions in images

Good luck, Luis

Re: how to select values from a field using other field

murozel76 — Wed, 12 Sep 2012 07:36:23 GMT

Hello Martin,

I use v11 and I can not see anything like "sheet object event triggers" when I go to "sheet properties-->triggers".

Please find attached my screenshot where there is only "sheet event triggers" frame. Do you thing there is something wrong with my set up,

or am I missing something?

I will be very pleased if you can help me on this.

Regards,

Re: how to select values from a field using other field

martinpedersen — Thu, 13 Sep 2012 15:06:22 GMT

Try select the list box preference instead the sheet preference.