topic Re: Start Date and End Date in QlikView

Start Date and End Date

Muthu — Wed, 28 Oct 2015 12:04:25 GMT

Hi Team,

In our Dashboard we have splitted the Master date to Month year day and time and dropped the master date.

I need to create a from date and to date using the same month year day and time.

When I have only date I followed approach used in this video and was able to achieve it.

Selecting Arbitrary Date Ranges

But after splitting the date I am not able to do the same.

Please help me

Thanks in advance.

Muthu

Re: Start Date and End Date

settu_periasamy — Wed, 28 Oct 2015 12:21:05 GMT

Hi Muthu,

is there any specific reason to dropped your master date?

or you can try to create the date using your month, day, year field with help of makedate() function..

Re: Start Date and End Date

Muthu — Wed, 28 Oct 2015 12:24:30 GMT

For Optimization part we have splitted the master date and took the year month and day.

Re: Start Date and End Date

settu_periasamy — Wed, 28 Oct 2015 12:52:16 GMT

Anyhow, you want the date right for your calculations, right?, then you can create the date using MakeDate function.

Re: Start Date and End Date

vishsaggi — Wed, 28 Oct 2015 13:04:16 GMT

Hi muthu,

As settu mentioned you can use makedate() function to get the date.

For start date and enddate try this and let us know.

Eg:

MasterTable:

Load *

MonthStart(Date) As StartDate,

MonthEnd(date) As EndDate;

Load Month, Year, Day,

Makedate(Year, Month, Day) As Date

From <YourTableName> ;

Try this and let us know if it works.

Thanks,
V.

Re: Start Date and End Date

vishsaggi — Wed, 28 Oct 2015 13:05:13 GMT

Sorry missed comma.

After Load * keep a comma.

Load *,

....

Thanks,
V.

Re: Start Date and End Date

Muthu — Thu, 29 Oct 2015 04:04:57 GMT

Hi,

Thanks for your reply.

Is there any way I can do this without using the makedate function in edit script,

because makedate function in the script will again increase the size of the dashboard.

Re: Start Date and End Date

settu_periasamy — Thu, 29 Oct 2015 04:39:49 GMT

Hi Muthu,

if you want the start date and end date, you need create the date field in the backend/frontend.

is it possible to post the sample data and expected output? that would be easier to help you

Re: Start Date and End Date

Muthu — Thu, 29 Oct 2015 08:42:19 GMT

Hi Settu,

if I can achieve this in the front end please tell me what are the steps.

Re: Start Date and End Date

settu_periasamy — Thu, 29 Oct 2015 09:24:23 GMT

Hi Muthu,

Can you post the sample of your qvw and expected output?