topic Select in Field Action - Timestamp Precision in QlikView

Select in Field Action - Timestamp Precision

Fri, 27 Jan 2012 11:38:33 GMT

When applying a timestamp based filter in an Select in Field Action, the filtering does not appear to be getting applied to the correct precision (see attached example). The same type of formula in the chart appears to behave correctly (I wouldn't expect the rows outlined in red to appear in the chart).

This is quite critical for implementing bitemporal reporting, so hopefully I'm just doing something silly. Thanks in advance for any pointers...

Select in Field Action - Timestamp Precision

pover — Fri, 27 Jan 2012 18:10:27 GMT

Change your search string in the "Select in Field" action to

='=[Start Date]<=Timestamp#(V.Test)'

Karl

Select in Field Action - Timestamp Precision

Fri, 27 Jan 2012 18:19:25 GMT

That did the trick. I'm new to QV, and finding the documentation a little light on information. Seems a little odd that you have to specify the field name in the "field" field, and then again in the "search string", but as long as it works...

Many thanks for your prompt response Karl!

Select in Field Action - Timestamp Precision

pover — Fri, 27 Jan 2012 23:20:47 GMT

Yeah, I can't tell you why, but the implicit search string structured "<=5" seems to be processed differently than explicit search string "=Field<=5". I tried manually searching for "<=41275.083333322" in the list box and get the same error.

They both should work, so you really might have found a bug.

The only you didn't need to put in your expression was the $() dollar sign expansion since the variable is a value and not an expression that you want to evaluate before evaluating the rest of the expression.

Karl

Select in Field Action - Timestamp Precision

Mon, 30 Jan 2012 08:36:38 GMT

Makes sense regarding the expansion. When not explicitly specifying the field name in the search string - presumably QV is heading down some other code path to build the search string formula internally, and one of the variables isn't typed to cope with the precision. I'll pass this info on to QV support. At least there is a work around - thanks again for your assistance.

Cheers,

Graeme

Select in Field Action - Timestamp Precision

Thu, 02 Feb 2012 11:58:43 GMT

Has been passed over to analysis team with ID 45150, so looks like a bug. Will update on outcome.

Select in Field Action - Timestamp Precision

Tue, 17 Apr 2012 08:05:08 GMT

This has been logged as bug 45150.