please I have this timestamp format in my database timestamp= 2016-11-01 00:00:00.0000000 +00:00 and I convert it to this format Date = 2016-11-01 by using this expression : Date#(SubField(timestamp, ' ', 1),'YYYY-MM-DD')
I want whenever I choose a date for example 2016-11-01, I want to get the value of this timestamp 2016-11-01 05:59:57.1810000 +00:00.
Hi Lou, what I see is a text box with the expression "=sum(VTagResolvedVirtual.ValueFloat)", so it sums all the values because the expression tells QV to sum the dates, you can use Min() or Max() to retrieve only one value.
Another option can be creating another table that loads the different dates and create the timestamp in this table, so there will be only one timestamp for each different date:
I tried before the expression : =Sum({<DD = {">=$(=Timestamp(Floor(Min(DD))+num(Maketime(05:59:57))))<=$(=Timestamp(Floor(Max(DD))+num(Maketime(05:59:57)))))"}>}VTagResolvedVirtual.ValueFloat)
but it didn't work, it also gives me the some for all the timestamps of the chosen date.
Hi Lou, that's what I said above, if you use Sum() QV will sum, and if it has x times the same value it will summ the x values, the option to add another table is to load only one value of each date, ahve you created this related table?
If you created the table maybe it's still retrieving more than one value for each date... there is only one VTagResolvedVirtual.TimeStamp for each VTagResolvedVirtual.ValueFloat? In that case maybe forcing to store only one value:
