Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Select the dates with time stamp

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

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Select the dates with time stamp

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

it's working fine.

7 Replies

Re: Select the dates with time stamp

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

LOAD TimeStampField,

          Date(Floor(TimeStampField)) as Date

Not applicable

Re: Select the dates with time stamp

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

Re: Select the dates with time stamp

I think reddys310‌ might be help you out here

reddys310
Honored Contributor II

Re: Select the dates with time stamp

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:

Capture.PNG

Thanks,

Sangram.

Not applicable

Re: Select the dates with time stamp

Hi sangram,

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

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

Regards,

Pramod

reddys310
Honored Contributor II

Re: Select the dates with time stamp

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.

Not applicable

Re: Select the dates with time stamp

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

it's working fine.

Community Browser