topic Re: select a date value in QlikView in QlikView

select a date value in QlikView

Mon, 26 Jan 2026 16:26:21 GMT

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.Text = @selection.selectionValue.ToString();

}

qvField.SelectValues(selectedFields);

}

Re: select a date value in QlikView

fdelacal — Mon, 05 Aug 2013 08:17:02 GMT

Try to do the num(2011-01-03) in other field.

This is better to see for qlikview.

Hope that helps you

Re: select a date value in QlikView

Mon, 05 Aug 2013 08:43:20 GMT

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.ToString(), out number))
{

ausgewaehlteFelder.Number = number;

}

Re: select a date value in QlikView

Mon, 05 Aug 2013 12:43:32 GMT

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?

Re: select a date value in QlikView

Wed, 07 Aug 2013 13:13:33 GMT

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.ToString();

if (DateTime.TryParse(val, out dateTime))

{

selectedFields.Number = Convert.ToDouble(qvDoc.Evaluate("=num('" + val + "')"));

selectedFields.IsNumeric = true;

}

else if (Int32.TryParse(val, out number2))

{

selectedFields.Number = number2;

selectedFields.IsNumeric = true;

}

else if (Double.TryParse(val, out number))

{

selectedFields.Number = number;

selectedFields.IsNumeric = true;

}

else

{

selectedFields.Text = val;

selectedFields.IsNumeric = false;

}

qvField.SelectValues(selectedFields);

}