topic Re: Use trigger to select text values in one field based on text values in another in QlikView

Use trigger to select text values in one field based on text values in another

Tue, 18 Jul 2017 15:26:21 GMT

How to get F3 values selected based on F1?

In F1 value C is selected , then in F3 TEXT3 should be highlighted green?

Thanks

Re: Use trigger to select text values in one field based on text values in another

sunny_talwar — Tue, 18 Jul 2017 15:56:02 GMT

May be like attached

Re: Use trigger to select text values in one field based on text values in another

Tue, 18 Jul 2017 17:14:28 GMT

Sorry but without F2. F1 value A selected gives F3 TEXT1.

Thanks.

Re: Use trigger to select text values in one field based on text values in another

sunny_talwar — Tue, 18 Jul 2017 17:37:10 GMT

How would I know which F1 is related to which F3? What's the relation between the two?

Re: Use trigger to select text values in one field based on text values in another

Tue, 18 Jul 2017 17:47:00 GMT

Hi ,

Relation is sequential order they appear 1 to 1.

F1 F3

A ---> TEXT1

B ---> TEXT2

C ---> TEXT3

D ---> TEXT4

E ---> TEXT5

Thanks.

Re: Use trigger to select text values in one field based on text values in another

sunny_talwar — Tue, 18 Jul 2017 18:11:12 GMT

Then why not create a relation between them in the script

Data1:

LOAD RowNo() as Key,

F1;

LOAD * INLINE [

];

Data2:

LOAD RowNo() as Key,

F3;

LOAD * INLINE [

TEXT1

TEXT2

TEXT3

TEXT4

TEXT5

TEXT6

TEXT7

TEXT8

TEXT9

TEXT10

TEXT11

TEXT12

];

Re: Use trigger to select text values in one field based on text values in another

Tue, 18 Jul 2017 19:20:44 GMT

Actually not 1 to 1 key should be removed.... What I'm trying to build is a simple questionnaire.

If user selects Q1 then automatically pertinent criteria gets selected from the fields user does't have to worry about it.

For example. If user selects Q1 then it should trigger say Option1 'TEXT5' and Option2 'TEXT12. Sounds simple enough. If it has to be hard-coded that is fine.

Thanks.

Re: Use trigger to select text values in one field based on text values in another

sunny_talwar — Tue, 18 Jul 2017 19:59:34 GMT

I am not sure I follow....How are you selecting TEXT5 and TEXT12 from Q1?

Re: Use trigger to select text values in one field based on text values in another

Tue, 18 Jul 2017 20:22:58 GMT

Image attached.

I need the above to occur only when I click Q1. It should highlight OPTION1 'TEXT5' and OPTION2 'TEXT12'

Buttons added for demo purposes only.

Thanks,

Re: Use trigger to select text values in one field based on text values in another

sunny_talwar — Wed, 19 Jul 2017 02:15:46 GMT

So you only need this for Q1, rest of the selections in Questions won't select anything?? This is just needed for Q1?

Re: Use trigger to select text values in one field based on text values in another

Wed, 19 Jul 2017 14:05:50 GMT

Well I would expect Q2 to Q12 behave similarly like Q1. Each question will have their own set of criteria field values triggered. If User clicks Q2 then only those criteria are automatically selected. Q2 may require OPTION1 'TEXT3' and OPTION3 'TEXT7' so on and so forth...

Thanks

Re: Use trigger to select text values in one field based on text values in another

sunny_talwar — Wed, 19 Jul 2017 14:08:08 GMT

But how do QlikView know about this? Is there a mapping available?

Re: Use trigger to select text values in one field based on text values in another

Wed, 19 Jul 2017 14:24:51 GMT

Can Qlikview trigger a button to run based on selection Questions list box. If user selects Q1 trigger button 'Q1 Criteria'. That would do the job. Then I would hide the buttons.

Thanks.

Re: Use trigger to select text values in one field based on text values in another

sunny_talwar — Wed, 19 Jul 2017 14:28:25 GMT

My friend, you can do this manual triggering into your actions, but you cannot trigger a button directly from a list box selection..... If you are going to create these 12 buttons, why not create a mapping table to make your life simple?