topic Calender for 3 DateTime fields in QlikView

Calender for 3 DateTime fields

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am struggling with my Data Model. Here I have 3 date fields in my table.

RequestTime, StartTime, EndTime.

I need assistance in how to create calendar out of these 3 fields?

I need to plot a chart with the analysis of

number of Requests Vs Number of Request Processed(Started).(per hour/day/Week/Month/Year)

Appreciate your assistance.

Thanks & Regards,

Poonam

Re: Calender for 3 DateTime fields

Anil_Babu_Samineni — Tue, 11 Apr 2017 16:02:06 GMT

Use This. It will come like below

Re: Calender for 3 DateTime fields

dathathreya — Tue, 11 Apr 2017 17:23:07 GMT

Hi poonam in your data the date field is same so far the time only changing so u can take any date.create a time bucket for the time.start and end.so by that u can plot the time interval.

Re: Calender for 3 DateTime fields

MarcoWedel — Wed, 12 Apr 2017 01:27:04 GMT

maybe helpful:

Canonical Date

regards

Marco