OnOpen select multiple values in a field based on another field

Wed, 22 Aug 2012 11:51:48 GMT

Hi,

I have looked through many other discussions on here but not found anything that answers my question.

I have a field "Stage" which is a grouping of dates (e.g.

'Stage 1' = 1-7 Jan,

'Stage 2' = 8-13 Jan,

'Stage 3' = 14-20 Jan,

etc).

When the document is opened I want to automatically select all the 'completed' Stages in an OnOpen document trigger.

Thus on the 15th Jan, 'Stage 1' and 'Stage 2' should be selected in the field "Stage", but not 'Stage 3' because it is not complete.

I have set up a new field called "Report_Stage" which lists the completed stages (using LOAD DISTINCT Stage where date>Today).

I want to set up the OnOpen trigger to set in the field "Stage" all the values from field "Report_Stage" in the Search String.

This is a text field so it needs a CONCATENATE of the individual values from "Report_Stage".

The examples I have seen so far use the GetFieldSelections function, but in my example the fields are not selected, I just want to get all values from the field.

Can anyone help with this?

Thanks.

topic OnOpen select multiple values in a field based on another field in QlikView

OnOpen select multiple values in a field based on another field