Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i need help i my qv aplications:
i have one table with 3 fileds: VisitorID, Visits.ComeIn, VisitsCome.Out
in last to fields contains time data. I need calculate visitors in some periods,
1. period 09:00-11:00
2.period 11:00-16:00
3.period 16:00 - 22:00
please help and sory for bad english, i hout you understand what i want...
Hi,
transform VisitComeIn e VisitcomeOut fields in Timestamp before And in number then:
1 Period= count(Distinct {<VisitComeIn={">=x"}, VisitComeOut={"<=y"}>} VisitID)
2 Period...
where x= num(VisitComeIn) and y=num(VisitComeOut)
could you please explain how to convert data...
x=num(Timestamp('09:00','hh:mm'))
y=num(Timestamp('11:00','hh:mm'))
z=num(Timestamp('16:00','hh:mm'))
...
ok, my expresion is: =count(DISTINCT{<Visits.ComeIn={">=num(Timestamp('09:00','hh:mm'))"}, Visits.ComeOut={"<=num(Timestamp('11:00','hh:mm'))"}>} VisitID)
but it returns 0..whats wrong?
The fastest way to get your issue resolved for such issues is to post a sample app you are trying with. Mean while try:
=count(DISTINCT{<Visits.ComeIn={">=Timestamp('09:00','hh:mm')"}, Visits.ComeOut={"<=Timestamp('11:00','hh:mm')"}>} VisitID) //i.e without num
No,
create 4 variables like these:
x=num(Timestamp('09:00','hh:mm'))
y=num(Timestamp('11:00','hh:mm'))
z=num(Timestamp('16:00','hh:mm'))
k=num(Timestamp('22:00','hh:mm'))
and then use this expression:
=count(DISTINCT{<Visits.ComeIn={">=$(x)"}, Visits.ComeOut={"<=$(y)"}>} VisitID)
...
still not working.., attched to my post a sample
Attach your qvw please
already atached (to my first post, visits.qvw)