topic Re: Timestamp in calender object in QlikView

Timestamp in calender object

Wed, 24 Feb 2016 17:24:37 GMT

Namaste,

can we add Timestamp in calender oject.

I mean, in slider/calender object, we can select the particular date from which we want to select the data

like that can we select the particular time in the calender object..

Thank you

Re: Timestamp in calender object

Gysbert_Wassenaar — Wed, 24 Feb 2016 17:59:13 GMT

No, the calendar object only understands dates. You can use the calendar object with a timestamp field, but you can only pick whole dates, not timestamp values.

Re: Timestamp in calender object

marcus_sommer — Wed, 24 Feb 2016 18:02:07 GMT

Not really - the calenderbox worked but showed only dates and would select all times which belonged to this date. Better would be to use a date maybe in this way: date(floor(YourTimestamp)).

- Marcus

Re: Timestamp in calender object

Wed, 24 Feb 2016 19:06:16 GMT

Hi, Thanks for the reply.

You mean, we can use timestamp, if we have the date value in the database with timestamp.. Is it??

Re: Timestamp in calender object

marcus_sommer — Wed, 24 Feb 2016 19:48:45 GMT

You could use a timestamp for it but it has the disadvantage that by selecting a date in them it will be select all timestamps which belong to that date and I don't believe that this is what you want.

I recommend that you used a master-calendar and if you really needed the time-part of the timestamps a master timetable and also to consider if you could remove the timestamp itself by transforming in:

date(floor(timestamp)) as Date,

time(frac(timestamp)) as Time

- Marcus

Re: Timestamp in calender object

Thu, 25 Feb 2016 13:57:42 GMT

Thank you

Re: Timestamp in calender object

Thu, 25 Feb 2016 13:57:55 GMT

Thank you

Re: Timestamp in calender object

oknotsen — Thu, 25 Feb 2016 16:24:17 GMT

If your question is now answered, please flag the Correct Answer.

If not, let us know what part of your question you still need help with .