topic Re: Master Calender problem with selections in QlikView

Master Calender problem with selections

Tue, 28 Aug 2012 07:15:36 GMT

Hi Experts

I have a problem with my master calender. I already made some applications with a working master calender but this one isn''t working.

I have a table called Contactmomenten with a field STARTDATETIME. I connected this field to the master calender.

When I check the mastercalender table i can see that the range of data that is autogenerated is correct

I put a Table box on the screen with two listboxes, Month and Quater to check wether my selections will work.

And this is the moment where is went wrong, i only see the data that is generated by the master calender.

So I if I don''t use any selection (Month or Quater) I see all the data (correct)

Does anyone has an idea what could be wrong? I attached my project in a zip

Update

There is also a enddatetime in the table, if i switch the mastercalendar to this date i have the same results, so then it also won''t work.

I also compared it with other applications from myself, with the same include (masterCalendar) and also a datetime field and i can''t see any differences

Re: Master Calender problem with selections

whiteline — Tue, 28 Aug 2012 08:14:01 GMT

The problem is that your calendar is for "days" but your data contains both "days" and "time".

"Day" with zero time in terms of data is an Integer value while "time" is its fractional part.

To connect your "day-callendar" you shoud create "days" (with zero time value) in your data.

Re: Master Calender problem with selections

Tue, 28 Aug 2012 08:18:08 GMT

I my following conclusion then correct:

Currently i have in my table a field called STARTDATETIME.

Besides this field, i should make a field STARTDATE (without time).

And on this field I should connect the mastercalendar?

Re: Master Calender problem with selections

Tue, 28 Aug 2012 08:32:17 GMT

i Tried the solution with a Startdate field in the table (without time).

But i still get the same results, so the selection won''t work.

Re: Master Calender problem with selections

whiteline — Tue, 28 Aug 2012 08:36:02 GMT

Yes, thats right if you want to use masercalendar to select your data by whole days regardless of the time.

To remove time from date value you can use floor function.

Re: Master Calender problem with selections

whiteline — Tue, 28 Aug 2012 08:37:46 GMT

Could you post how you have created STARTDATE or the whole example again ?

Re: Master Calender problem with selections

Tue, 28 Aug 2012 08:40:43 GMT

I uploaded a new file with the the suggested solution

As you can see i used: Date(STARTDATETIME) AS STARTDATE,

Re: Master Calender problem with selections

whiteline — Tue, 28 Aug 2012 08:57:10 GMT

You have changed the text format of date while I suggested to change the numerical values.

See the screen attached. You have two different values of STARTDATE that just look the same.

Re: Master Calender problem with selections

Tue, 28 Aug 2012 09:01:07 GMT

Can you attache the solution?

or just use:

Floor(STARTDATETIME) AS STARTDATE,

instead of:

Date(STARTDATETIME) AS STARTDATE,

Re: Master Calender problem with selections

whiteline — Tue, 28 Aug 2012 09:05:00 GMT

Yes, use Floor. It changes the value.

Date function only changes its text representation.

You can use it to change the format (the look) from 'YYYY-MM-DD' to 'DD.MM.YY' for example and so on.