topic Re: Date Rang in QlikView

Date Rang

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to create date range that the user can select the data by date ranges

when the user selects the date I want him the select the date in the format:'YYYY/MM/DD hh:mm'

for example, I want to display the data between the dates

2017-07-16 20:00:00 and 2017-07-17 13:00:00

Attached an example

Thanks

Re: Date Rang

Anil_Babu_Samineni — Tue, 18 Jul 2017 13:15:04 GMT

What was the logic behind ??

Re: Date Rang

vishsaggi — Tue, 18 Jul 2017 14:13:21 GMT

Check Here:

Calendar with time (timestamp)

Re: Date Rang

Wed, 19 Jul 2017 06:23:05 GMT

hi,

I want to create in the UI an 'Input box' that will include two variables

1. VstartDate

2. VendDate

in the 'Input Box' I want the user to select a date and time Range

when the VstartDate will display the start day and the VendDate will display the end date.

the format of the date will be : 'YYYY/MM/DD hh:mm'

how can i create this 'Input box' ?

for example, I want to display the data between the dates

2017-07-16 20:00:00 and 2017-07-17 13:00:00

Re: Date Rang

techvarun — Wed, 19 Jul 2017 06:51:13 GMT

Selecting Arbitrary Date Ranges

Re: Date Rang

Wed, 19 Jul 2017 07:08:40 GMT

This is not what I was looking for, because I want the user to select date and time range.

Re: Date Rang

Anil_Babu_Samineni — Wed, 19 Jul 2017 08:11:18 GMT

I am not sure, To whom you are replying? Any how - Here is the approach where we can

Create 2 variables by help of Timestamp() this will return as you expected rather Date() function

Re: Date Rang

Wed, 19 Jul 2017 09:20:20 GMT

hi Anil,

I'm not sure what you mean...

I think the problem is with my MasterCalendar, I think I need to customize it so that it holds time too, using timestamp.

and after so, I need to create the 'Input Box' in the UI that will hold the date and the time range.

please see the attached qvw.

Re: Date Rang

Anil_Babu_Samineni — Wed, 19 Jul 2017 09:33:25 GMT

I don't think why Master calendar, Looks good to me. And nevertheless May be explain in detail with sample data set. Off course, I've seen the inline data but i am not understand the business because you have only 2 dates. Can you explain what if you have 10 rows with different fields. What are trying now ??

Re: Date Rang

Wed, 19 Jul 2017 09:45:53 GMT

this is an example qvw, the real qvw include million of data.

i want the user to select a range of date-time

(for example from 2017-07-16 20:00:00 to 2017-07-17 13:00:00).

It's very hard to use a list box because of the numbers of records inside the range.

I'd prefer an input box for the date-time selection (from and to) and the selection of the records based on them.

I think I have a problem with my MasterCalendar because of the column: SaleDate_DateTimeFormat

It shows the same time on every date

2017/07/16 20:00:00

2017/07/17 20:00:00