Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Highlighted
hopkinsc
Valued Contributor II

Trouble with Start and End Dates

Hi, i have tried putting start and end date calenders in my application but i can't get them to work.

Is it possible that someone could take a look at the sample i have attached to see what i'm doing wrong??

Any help would be greatly appreciated

Thanks

10 Replies
Not applicable

Trouble with Start and End Dates

We can help you out only if you can tell us what exactly the issue is. Just attaching the application is not going to help us...

hopkinsc
Valued Contributor II

Trouble with Start and End Dates

Silly me!!

The issue is that when i enter both dates, it displays dates outside the range.

Thanks

Not applicable

Trouble with Start and End Dates

Refer the application and do exactly what was done in the attached document! That will defiantly give solution for the problem that you are facing!

hopkinsc
Valued Contributor II

Trouble with Start and End Dates

Hi, thanks for your reply.

I have copied what you have done, i.e. the variables and the calender settings, but they still do not work. i'm lost...

I have attached the version with the changes i copied from your document.

Not applicable

Trouble with Start and End Dates

Hi Hopkin,

I am not able to find it out what the problem you are facing. Could you please attach the screen shot for the same.

hopkinsc
Valued Contributor II

Trouble with Start and End Dates

here is a screen dump.

As you can see, i have entered a start date of 29th Aug 2010 and an end date of 31st Aug 2010 but the results are showing dates 28th Aug 2010.

Also i have noticed that after selecting dates, nothing appears in the current selections box, But on your example that you attached, the current selection boxes changes as soon as you select a date.

Could this be the problem?

Trouble with Start and End Dates

Hello,

It looks like a date formatting issue. Try creating a new TransDate field with function Date(), so your set analysis looks like

{< TransDate = {">=$(=Date(vStartDate))<=$(=Date(vEndDate))"} >}


Hope that helps

hopkinsc
Valued Contributor II

Trouble with Start and End Dates

Thanks Miguel, it looks like it was a formatting issue.

My date format was WWW DD-MMM-YYYY giving SAT 04-SEP-2010, i changed it to the default date format DD/MM/YYYY and it worked.

Thanks for your help.

hopkinsc
Valued Contributor II

Trouble with Start and End Dates

I still do not understand why the dates selected do not appear in my CURRENT SELECTIONS BOX?

Does anyone know why?

Community Browser