topic Setting a field based on another field in QlikView

Setting a field based on another field

Fri, 13 Jan 2012 19:59:38 GMT

I know there is an easy way to do this but I can't figure it out. When selecting a value in a list box from one field I want that same value selected in a different field. I was looking into a document trigger but that doesn't seem to be the place to do this. Suggestions?

Setting a field based on another field

Fri, 13 Jan 2012 20:41:50 GMT

I just tried it and it worked fine from Settings > Document Properties > Triggers tab > Field Event Triggers.

You just add an "OnSelect" action on Field1 (where you'll select the value): "Select in field".

Then in the "Field" zone you type the name of the 2nd field as it is, and in the "Search String" zone you type =Field1.

Is that the way you were trying to do it ?

Setting a field based on another field

Fri, 13 Jan 2012 22:23:47 GMT

JP - Perfect explanation and works like a charm. I was 90% there but couldn't figure out exactly what to put in the "Select in field" expressions. Your help is greatly appreciated!