I have setup the QlikView OCX to work in my C# winforms app. I have gathered all possible field values for the specific fields that I am looking to target. I have created selectors that hold that data in .NET controls. The user would make selections within the .NET controls and click a button to set the field values.
I can easily set a field value for one of the fields. For example I am having no problem setting the date when that is the only option selected. However, if the user then makes a "company" selection along with the date selection, only the company selection is set. I can see in my current selections object that the date was initially set, very briefly, then when the company gets set it overrides the previous date selection. All I am left with is just the company selection, no date.
Here is the code I have:
private void SetValues()
{
Field dateField = qvDoc.GetField("Date");
dateField.Clear();
IArrayOfFieldValue selectedDateFields = tradeDateField.GetNoValues();
selectedDateFields.Add();
selectedDateFields[0].Number = Convert.ToDouble(qvDoc.Evalueate("=num('" + (DateTime)ddlDate.EditValue _ "')"));
selectedDateFields[0].IsNumeric = true;
dateField.SelectValues(selectedDateFields);
Field companyField = qvDoc.GetField("Company");
companyField.Clear();
IArrayOfFieldValue selectedCompanyFields = companyField.GetNoValues();
for (int i = 0; i < selectedCompanies.Count; i++)
{
selectedCompanyFields.Add();
selectedCompanyFields[i].Text = selectedCompanies[i];
}
companyField.SelectValues(selectedCompanyFields);
}
When running that method I would expect to see my current selections set with a date and company. Only the company is being set. What am I missing? Why does this remove my previous selection?