topic Re: Forcing data into a field in QlikView

Forcing data into a field

david_ze — Thu, 16 May 2013 12:37:41 GMT

Hi all,

Need your help on how to force data into a field.

I have two fiels 'Project_Number' and 'Project_Ref' which are not connected directly.

I would like to fill 'Project_Ref' field with the numbers I get when choosing the field 'Project_Number'.

'Project_Ref' contains the same data as 'Project_Number'.

It should be like this:

If I choose the numbers 1,7 and 55 from field 'Project_Number' the system should choos the same numbers in field 'Project_Ref'.

Would appreciate you prompt response.

Best

David

Re: Forcing data into a field

Gysbert_Wassenaar — Thu, 16 May 2013 12:41:39 GMT

You need to add a Select in Field action to the OnSelect trigger of the Project_Number field. The field to select in would be Project_Ref and the search string would be ='(' & concat(distinct Project_Number, '|' & ')'.

Re: Forcing data into a field

Thu, 16 May 2013 12:42:12 GMT

if(Project_Ref = Project_Number,Project_Ref) as Project_Ref_match

Re: Forcing data into a field

Anonymous — Thu, 16 May 2013 12:51:33 GMT

See attached