Select the dates with time stamp

[#1]

Hi all,

I am using a DateRangePicker custom extension downloaded from Qlik Branch.

In  a sheet, i am using the DateRangePicker to filter the value in the table.

where, Column1 : hour(CanonicalDateTime) - hours from 0 to 23

           Column2 : count({$<DateTimeType = {'signed_time'},user_signed={1}>}invitation_id) -- count corresponding to that hour

If i select a date in a DateRangePicker,  it should select the hour and count in the table of that date.

Regards,

Pramod

[sunny_talwar]

Are you using your TimeStamp field to create your date field? May be like this:

LOAD TimeStampField,

          Date(Floor(TimeStampField)) as Date

[#3]

hi sunny,

Thanks for the reply, i am using a DateRangePicker custom extension downloaded from Qlik Branch.

In  a sheet, i am using the DateRangePicker to filter the value in the table.

where, Column1 : hour(CanonicalDateTime)

           Column2 : count({$<DateTimeType = {'signed_time'},user_signed={1}>}invitation_id)

If i select a date in a DateRangePicker  it should select the hour and count in the table of that date.

Regards,

Pramod

[sunny_talwar]

I think reddys310‌ might be help you out here

[reddy-s]

Hi Pramod,

Can you not add a time stamp as 00:00:00 to the dates where there is no timestamp?

I have use a range selector like this and works perfectly:

Thanks,

Sangram.

[#6]

Hi sangram,

i'm talking about the SenseDaterangePicker, Not the range selector

GitHub - NOD507/SenseDateRangePicker: A date range picker extension for qliksense

Regards,

Pramod

[reddy-s]

Hi Pramod,

Looks like this extension takes only the date field and not a date time field. Is it possible to create an other field with truncated time and use that in the extension?

Thanks,

Sangram.

[#8 · Accepted solution]

I used dimension as date(floor(CanonicalDateTime),'MM-DD-YYYY')

it's working fine.