topic Re: Need help in QlikView

Need help

Sat, 14 Dec 2013 14:51:01 GMT

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...

Re: Need help

Sat, 14 Dec 2013 14:57:10 GMT

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)

Re: Need help

Mon, 16 Dec 2013 06:57:01 GMT

could you please explain how to convert data...

Re: Need help

Mon, 16 Dec 2013 09:20:38 GMT

x=num(Timestamp('09:00','hh:mm'))

y=num(Timestamp('11:00','hh:mm'))

z=num(Timestamp('16:00','hh:mm'))

...

Re: Need help

Mon, 16 Dec 2013 10:07:03 GMT

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?

Re: Need help

tresB — Mon, 16 Dec 2013 10:14:08 GMT

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

Re: Need help

Mon, 16 Dec 2013 10:16:13 GMT

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)

...

Re: Need help

Mon, 16 Dec 2013 10:57:40 GMT

still not working.., attched to my post a sample

Re: Need help

Mon, 16 Dec 2013 10:59:55 GMT

Attach your qvw please

Re: Need help

Mon, 16 Dec 2013 11:13:09 GMT

already atached (to my first post, visits.qvw)

Re: Re: Need help

tresB — Mon, 16 Dec 2013 11:25:47 GMT

I guess, it would be easier if you try with Class() function like attached sample.

Re: Need help

Mon, 16 Dec 2013 11:58:51 GMT

thanks, but dont know how to modificate this example for my issue....if its possible..