Modify Calendar

[Pomna]

Hello Experts I need help modifying a calendar.  this calendar comes from a qvd that am not allowed to modify.

Reports have gaps as shown on the report below

How do I modify the load script so that my calendar starts from 2016Q3 and get rid of the empty spaces on the visualization? Thanks for your suggestions

[marcus_sommer · Accepted solution]

AFAIK you could disable the displaying of zero's within the chart-settings. Also you could apply this as condition within a calculated dimension.

But if it's not really related to this chart else the whole application has only values since 2016Q3 it would be useful to remove the older ones within the script just by applying a where-condition, like:

Cal: load * from CalQVD (qvd) where Date >= '07/01/2016';

You need to adjust this to the real date-field (name and formatting) within your qvd. It doesn't change the qvd else it loads just a part from it.

- Marcus

[jonathandienst]

Or you could align the calendar withe the rest of the model using a Left Keep qualifier on the load.Something of this pattern:

Left Keep(<fact table name>)
LOAD * From Calendar.qvd

The keep is like a join in that it only returns the matching values, but instead of adding the fields to the left table, it keeps them in a separate table. This will filter the calendar to match your "fact" table".

[Pomna]

Thank you Marcus I applied the where condition to limit the date from >= 2016Q3 and it solved my problem