topic Please Help!! MasterCalendar in Script, but dates not showing on Frontend in QlikView

Please Help!! MasterCalendar in Script, but dates not showing on Frontend

Anonymous — Thu, 10 May 2012 07:46:03 GMT

Not sure why no data appears for any of my calendar fields.

Please Help!!

Thu, 10 May 2012 08:01:20 GMT

Hi chris,

First i tried to open the qvw and look at the model, and could not see anything.... And cannot do a reload, as i dont have the qvds.

However, I tried to comment out everything and just keep the Master calendar you had created...

And it looked good. I could see all the date fields.

I have modified the qvw (please find attached)....

You may want to re-check your script.

Thanks,

Robinson

Anonymous — Thu, 10 May 2012 08:05:47 GMT

Any ideas about what in the script could be causing the date fields to come up blank when everything isn't commented out??

Thu, 10 May 2012 12:51:02 GMT

It is more than likely this:

LEFT KEEP (Transactions)

Try removing that to see if you get the dates. It probably means that the date formats are different or something along those lines.

Edit:

I think that your field YearMonth is lacking an actual date, so that the formula:

(Date(Date#(YearMonth,'YYYY-MM-DD'),'DD/MM/YYYY'))

does not return a value as it does not have a day field. I tried it in a list box and it returns no value

Anonymous — Thu, 10 May 2012 12:58:58 GMT

thanks marc

I got it figured out before.

The date formats I had in my transactions table were not matching the formats I had in my MasterCalendar