topic Re: Connected users chart in QlikView

Connected users chart

cicciput — Thu, 23 Jan 2014 22:05:00 GMT

I have a table Connections, related to users connected to a streaming service, with connection and disconnection time — which always occur in the same day.

I need to create a chart showing

on x-axis: time — by minute or by 10 minutes
on y-axis: number of users connected

How can I achieve it?

Thanks for your help

Re: Connected users chart

Colin-Albert — Thu, 23 Jan 2014 22:15:29 GMT

Henric's post on creating missing data should answer your question.

Generating Missing Data In QlikView

See the example for creating data on each day a contract is valid.

Re: Connected users chart

cicciput — Thu, 23 Jan 2014 22:57:24 GMT

Yes, thanks, very helpful link.

As a novice tho I cannot get how to round by single hour:minute — or 10 minutes.

I mean: to get following date I use

Date( FromDate + IterNo() – 1 )

i.e. I sum 1.

How about single minute?

How do I round by minute?

How do I increment by minute?

Thanks for your patience

EDIT

I got how to round by minute:

time(frac(floor(MyTIME, 1/1440)),'hh:mm')

Re: Connected users chart

Colin-Albert — Thu, 23 Jan 2014 23:41:55 GMT

It may be easier to convert the start and end time data to an integer minutes since midnight, and increment by the minute rather than working in fractions. You can then analyse the data by the minute, 10min or other intervals in your chart.