topic Re: select field when another field is selected in QlikView

select field when another field is selected

felcar2013 — Wed, 24 Apr 2013 13:15:31 GMT

I need help on this. I need that when i select a value from member_timestamp (from file attached) i get a corresponding field value in the transaction_numeric_date selected. this correspondence rule is based on the timestamp numeric value and the transaction numeric value.

thanks for any help

Felipe

Re: select field when another field is selected

Gysbert_Wassenaar — Wed, 24 Apr 2013 14:19:09 GMT

You can use a Clear Field action followed by a Select Possible action. See attached example.

edit: I misread your requirement. See attached update example instead.

Re: select field when another field is selected

felcar2013 — Wed, 24 Apr 2013 15:10:44 GMT

thanks. When i click on my field value (member_timestamp) i get all possible value fields selected in the transaction_numeric_date listbox. (i changed the field name in both actions you proposed).

However, i want to select a value of the member_timestamp list box. This field has a counterpart with the member_timestamp_numeric (1 to 1) so that i only have a unique possible value to select. This value shall automatically be selected in the transaction_numeric_date list box (here the list of field values exceeds 1900).

Ex. I selected 2013-02 (member_timestamp), value in member_timestamp_numeric = '41328'. This is the value i have to automatically look for and select in the transaction_numeric_date list box.

further comments very welcome, thanks for your help

Re: select field when another field is selected

felcar2013 — Wed, 24 Apr 2013 16:44:49 GMT

excellent, thanks for your help

Re: select field when another field is selected

felcar2013 — Thu, 25 Apr 2013 10:58:19 GMT

do you know, how can i make the rest of list boxes or possible selection from the "transaction_date" selection / filter

independent?

now when i select timestamp, i have at the same time selected the transaction date, which afects my document. How can i detach this "transaction_date" filter, and make it only valid for my chart?

any help very welcome

thanks

felipe

Re: select field when another field is selected

Tue, 25 Apr 2017 19:42:33 GMT

I was wondering if you could help me with the same thing he wants. In my case, when Inquiry Subtype is selected, corresponding address is selected as well