It working for me, but your output is wrong
For Alert 3 you will get Count =1 only (bcz both IDs are same)
chaining.qvw 144.5 K
Year(Zeitstempel) as ZS_Jahr,
month(Zeitstempel) as ZS_Monat,
day(Zeitstempel) as ZS_Tag,
Time(Zeitstempel) as ZS_Uhrzeit,
Hour(Zeitstempel) as ZS_Stunde,
Interval(Now()-Startzeit,'hh') as Alter,
drop Table Datenload;
Alter as Alter2,
Proben_ID as Proben_ID2
count(Proben_ID2) as number
Group by Alter2;
DROP Table Zwischenschritt;
thank you all - Now I know the problem - but not the solution.
The Problem seems to be in the buidling of "Alter" by this function "Interval(Now()-Startzeit,'hh') as Alter".
That seems to be the reason why group by doens't work.
Startzeit is "2016-07-29 13:40:13.28" and it is different for all the values, but I want to get the answer from "Interval(Now()-Startzeit,'hh') in hours.
Can you help for this or any ideas?
Interval() does not round the numbers to the nearest hour, it simply formats them. To round the values of the interval, you will need this:
Interval(Floor(Now() - Startzeit, 1/24), 'hh') as Alter,
(assuming Startzeit is a numeric date value (right aligned in a list box). If it is a string value, you will need:
Interval(Floor(Now() - Time#(Startzeit, 'dd-MM-yyyy hh:mm:ss.ff'), 1/24), 'hh') as Alter
(play around with the format string to match your date format. Better still, convert it to a date on load)