topic Macro event doc.fields in QlikView

Macro event doc.fields

siddharth_kulka — Wed, 23 Jun 2010 19:54:47 GMT

Business Rule:

There is a generic rating field one tab with values 1,2,3,4,5,6,7,8,9,10

On a different tab, there are product wise ratings Product A: 1,2,3,4,5,6,7,8,9,10 Product B: 1,2,3,4,5,6,7,8,9,10

Goal: If I select 10 in generic field, 10 should be selected in product A and product B list boxes

I want to pass multiple fields(parameters) in doc.fields event, but I don't think it is permitted. Is there a work around? I am achieving my goal by writing multiple doc.field statements, but its not the best way to do it, one feels

Below is working code, but is there any way to avoid these multiple doc.fields statements?

set Doc = ActiveDocument
set F1_Selections = Doc.fields("CPR_Rating").GetSelectedValues
set F2 = doc.fields("A")
set F3 = doc.fields("B")
F2.SelectValues F1_Selections
F3.SelectValues F1_Selections

Any help will be appreciated.

Thanks,

Siddharth

Macro event doc.fields

johnw — Wed, 23 Jun 2010 20:10:55 GMT

Well, there might (or might not) be a better way, but that IS basically how I've done it in the past when I've needed to syncrhonize fields without actually making them the same field in the model.

Macro event doc.fields

Wed, 23 Jun 2010 20:56:30 GMT

Hi Siddharth,

Please see attaced qvw, I hope you are looking for this. I have trigger on ValGen filed chage, it calls macro SelectTest and selects corosponding vales in producta and productb. This is just to give you an idea.

Macro event doc.fields

siddharth_kulka — Wed, 30 Jun 2010 22:00:39 GMT

Thanks John!

Devang,

The test qvw is throwing out an error. Are the functions array() and MultipleFieldSearch() valid functions?

I tried looking up the APi for both 8.5/9.0, but coudn't trace them?

Thanks,

Siddharth