Discussion board where members can learn more about Qlik Sense App Development and Usage.
Hi Fellow Qlikers,
I am trying to search a column of a table. The field coming from db is a timestamp field.
Is there a way i can ignore the timestamp and just be able to write my search condition as >=02/20/2020 and it still fetches me results
I attempted to replicate this on my end, but I'm getting the correct values returned when I search like you described (albeit with a different timestamp format):
It looks like your values are correct timestamps, so I wonder if this might be related to the formatting somehow...
Nothing specific - if you could provide sample data, perhaps the issue will be visible, but working blindly I have no recommendation except to explicitly format the field in question as e.g. Timestamp(Field) or Timestamp#(Field) as appropriate.
Also, if you don't need the timestamp aspect at all, it'd probably be better to just filter on a date field, e.g. dayname(Field).
Well, sorry I'm no help, but I'm officially confounded here.
Load Timestamp(Now(),'DD/MM/YYYY hh:mm:ss') as TestTime
Load Timestamp#(TimeStamp,'DD/MM/YYYY hh:mm:ss') as TimeStamp INLINE [
01/01/2020 3:33:33 ];
Both fields get picked up as $numeric and $timestamp, but TestTime won't let me search e.g. >01/01/2020 whereas TimeStamp will let me search e.g. >01/01/2020.
Either I'm missing something (likely) or this is some sort of bug / unintended behavior / something of that nature (less likely), but I'm fresh out of ideas as to what I might be missing.
HI @eddie_wagt with the dual function it definitely helped be search. So that's what i wanted, But this formula is eating up a part of my data.
If you look at the image the dates highlighted in yellow does not show when we use dual function. What i feel its doing is showing just one timestamp entry for March 2nd