Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I used dimension as date(floor(CanonicalDateTime),'MM-DD-YYYY')
it's working fine.
Are you using your TimeStamp field to create your date field? May be like this:
LOAD TimeStampField,
Date(Floor(TimeStampField)) as Date
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
I think reddys310 might be help you out here
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.
Hi sangram,
i'm talking about the SenseDaterangePicker, Not the range selector
GitHub - NOD507/SenseDateRangePicker: A date range picker extension for qliksense
Regards,
Pramod
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.
I used dimension as date(floor(CanonicalDateTime),'MM-DD-YYYY')
it's working fine.