topic Damn Blanks! in QlikView

Damn Blanks!

samvile18 — Fri, 15 Jul 2011 14:14:51 GMT

Hello all,

Can any of you help with the following problem please: -

I have a QVW file that links to several different data sources and pulls a list of tables together, it links all tables with the Master Calendar using the field EctractDate. One of my tables (NGPActionLogger) though seems to be returning blanks when I try and select a specific month or year....I really have no idea why. This is a copy of the table layout, is it a date formatting problem??

Any help is greatly appreciated.

Damn Blanks!

johnw — Fri, 15 Jul 2011 22:18:29 GMT

It certainly could be a date formatting problem. If, say, the NGPActionLogger table had a text value for the date like '2011/7/15', this would not match up to a MasterCalendar using actual date values for the date.

Damn Blanks!

samvile18 — Mon, 18 Jul 2011 09:16:01 GMT

Hi John,

Thanks for the reply...I did some digging and found that for some reason my Master Calendar has randomly stopped creating the month and year of my extract date, I have no idea why but I think this is why the graphs are showing no data when a month is selected.

Have you ever heard of this before, I've attached a copy of the table?

ExtractDate Month Year

25/05/2011 5 2011

26/05/2011 5 2011

27/05/2011 5 2011

28/05/2011 5 2011

29/05/2011 5 2011

30/05/2011 5 2011

31/05/2011 5 2011

01/06/2011

02/06/2011

03/06/2011

05/06/2011

06/06/2011

07/06/2011

08/06/2011

09/06/2011

10/06/2011

12/06/2011

13/06/2011

14/06/2011

15/06/2011

Damn Blanks!

samvile18 — Mon, 18 Jul 2011 10:10:22 GMT

I figured it out!!!

It was happening because the min and max variables of the script were coming from a table with a smaller date range than the results I was trying to look at!!

To get around it I loaded a temp table which holds all dates from 2008-2012 so we always know what the min and max dates will be.

Phew...that was starting to worry me!