Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

chrisgoudy
New Contributor II

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

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

Please Help!!

4 Replies
Not applicable

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

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

chrisgoudy
New Contributor II

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

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

Not applicable

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

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

chrisgoudy
New Contributor II

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

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

Community Browser