topic dummy date values in graph in QlikView

dummy date values in graph

Thu, 17 Feb 2011 12:00:01 GMT

I have a line graph. the dimension is a DB date in the format 'MMM YYYY' then the expressions are data items (numeric) associated with this date.

My problem is, I want to include all dates for the next 2 years along the graph, but still have the data attached to the DB date (with zero value if date not on DB).

e.g.

Jan 2010 has value of 20

Feb 2010 has value of 30

Apr 2010 has value of 40

Jun 2010 has value of 50

I want Mar 2010 to appear on the graph with value of zero even though the date doesn't exist on the DB?

Thanks

dummy date values in graph

Thu, 17 Feb 2011 12:05:35 GMT

In presentation tab uncheck delete vull value

dummy date values in graph

Thu, 17 Feb 2011 12:07:28 GMT

If you want that Mar 2010 appear, it should exist on the DB.

dummy date values in graph

Thu, 17 Feb 2011 12:14:46 GMT

Thanks - I wondered if there was a way to "merge" the dates that don't exist on the DB into the dimension array of dates from the DB?

dummy date values in graph

Anonymous — Thu, 17 Feb 2011 12:54:05 GMT

What you need is a calender that generates all months for you.
This way you can select the month from the calander and not the month from you database.

dummy date values in graph

Anonymous — Thu, 17 Feb 2011 14:43:03 GMT

Hi Paula,

I made a little example for you.

In this document I created a master calender which starts on the first day of the "Date"-field from my excel document and ends on the last day of that field. But it creates all days in between. In my Excel document I don't have any data for Februari 2010 but as you can see it does show in the charts.

Check the load script of the Qlikview document to see what I have done.

If you have any questions just let me know.

Good luck.

dummy date values in graph

Thu, 17 Feb 2011 14:56:37 GMT

Thank You Dennis,

I'll take a look at it!

Paula

dummy date values in graph

Fri, 18 Feb 2011 11:56:48 GMT

BRILLIANT!! Thanks Dennis

Paula

dummy date values in graph

Anonymous — Fri, 18 Feb 2011 12:23:06 GMT

Glad you like it.

Don't forget to verify the answer

If you have any questions just let me know.

Good luck with Qliking 🙂