topic Re: Multiple Dates in QlikView

Multiple Dates

hopkinsc — Thu, 30 May 2013 08:18:40 GMT

Hi everyone,

I have multiple dates in my application. I am trying to think of the best way to handle them so users can choose a date from either of the date fields easily.

I have thought of doing the following but unsure if and how it can be done..

1. Create a date island

2. The user selects a date from the new date island and then selects which date they want to use (Start, Completed, Raised)

3. This then selects the island date selected in the required date field.

I have attached a sample.

Any help or other suggestions will be appreciated

Many thanks

Re: Multiple Dates

alexandros17 — Thu, 30 May 2013 08:29:08 GMT

It's a good idea, but each type of date have a specific meaning so I would prefer three fields in multi selection box each one on a date.

Re: Multiple Dates

hopkinsc — Thu, 30 May 2013 08:35:21 GMT

hi Alexandros,

Thanks for your reply

although its not just 3 fields (i have only put 3 in my sample)

there will be:

Specific Date

Month

Year

Quarter

for each Date selection (12 fields in total) which is why i thought that having a multi box would be messy and not very user friendly.

Re: Multiple Dates

er_mohit — Thu, 30 May 2013 09:41:19 GMT

Hii For this

You have to make master calender then using floor function with your different date you can link with this calender.

make sure that the date format for all datefield is same .Hope it helps You

you could join also for doing that but it quite complicated table because your all Fact tables are attached in one table

Hope it helps you

Re: Multiple Dates

hopkinsc — Thu, 30 May 2013 10:03:06 GMT

Hi, thanks for your reply. I wanted to try and get it working with the example i have posted,

Does anyone know if it's possible

Re: Multiple Dates

hopkinsc — Thu, 30 May 2013 11:18:18 GMT

Does anyone have any ideas ?