Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey together,
I am using some OCX Code to make a selection in my QlikView-Application, it is working so far for me. But now I have discover some problems, I have try to select some date value e.g. 2011-01-03, this selection won't be work by my code, is there some workaround???
//clear selection on my QlikView-App
qvDoc.ClearAll();
//I have declared some object with holds the information about the selection, that must be selected
for (int i = 0; i < selection.Count; i++)
{
Field qvField = qvDoc.GetField(QLIKVIEWFIELD);
IArrayOfFieldValue selectedFields = qvField.GetNoValues();
for (int j = 0; j < selection.selectionValue.Count; j++)
{
selectedFields.Add();
selectedFields
}
qvField.SelectValues(selectedFields);
}
DateTime dateTime;
Double number;
Int32 number2;
for (int i = 0; i < selection.Count; i++)
{
Field qvField = qvDoc.GetField(QLIKVIEWFIELD);
IArrayOfFieldValue selectedFields = qvField.GetNoValues();
for (int j = 0; j < selection.selectionValue.Count; j++)
{
selectedFields.Add();
string val = @selection.selectionValue
if (DateTime.TryParse(val, out dateTime))
{
selectedFields
selectedFields
}
else if (Int32.TryParse(val, out number2))
{
selectedFields
selectedFields
}
else if (Double.TryParse(val, out number))
{
selectedFields
selectedFields
}
else
{
selectedFields
selectedFields
}
}
qvField.SelectValues(selectedFields);
}
Try to do the num(2011-01-03) in other field.
This is better to see for qlikview.
Hope that helps you
Facundo de la cal, good idea, but it doesn't work for me.
Here I havwe a try with a number, the selection of a number is also not working
if(Double.TryParse(selection.selectionValue
{
ausgewaehlteFelder
}
I play a little bit with the OCX API, something that I recognized was. That I am can select one Date value or number from a certain field.
Field qvField = qvDok.GetField(SOME_QLIKVIEW_FIELD);
qvField.Select("2011-03-01");
This is a little strange I think, maybe there is some bug in the API?
DateTime dateTime;
Double number;
Int32 number2;
for (int i = 0; i < selection.Count; i++)
{
Field qvField = qvDoc.GetField(QLIKVIEWFIELD);
IArrayOfFieldValue selectedFields = qvField.GetNoValues();
for (int j = 0; j < selection.selectionValue.Count; j++)
{
selectedFields.Add();
string val = @selection.selectionValue
if (DateTime.TryParse(val, out dateTime))
{
selectedFields
selectedFields
}
else if (Int32.TryParse(val, out number2))
{
selectedFields
selectedFields
}
else if (Double.TryParse(val, out number))
{
selectedFields
selectedFields
}
else
{
selectedFields
selectedFields
}
}
qvField.SelectValues(selectedFields);
}