As I understand, you're pivoting the "Date" field. Before you pivoted the "Date" field, it's in rows and once you pivoted it's moved to columns for each possible "Date". You can two options:
1. Enable "Show All Values" on "Date" dimension
2. Un-check "Surpress NULL values" in the presentation tab
Prefered Option 2:
For each distinct "Type" field value and concatenate this table by filling "-" or other symbol. This way you will always have a value for each "Date" field and you will always see all the dates after pivoting.
I hope this helps!
If you don't have dates for every Type you'll need to build out a date calendar and use a date field with all dates. This is done in the load script. Under //logic to add all dates you will see a routine to fill in all dates within the date range in your data source. In your chart , use 'ChartDate' instead of 'Date' as the dimension .
OrderDate as "Date",
//logic to add all dates
max(Date) as MaxDate,
min(Date) as MinDate
date(RecNo()-1 + $(vMinDate)) as ChartDate
drop table MaxMinDates;
left join (Dates)
Date as ChartDate,
Understood! Option 1 will not work when you want to filter on "Type" field.
It's easier if you have sample QVW and I can mock up something for you. Or else, you need:
LOAD DISTINCT "Type", "Date", "-" AS Flag
You need to concatenate the above table to your main table. This way you will have "-" value no matter what you select in "Type". It might look strange to see the last row as "-" but it will give you all the rows/Dates.
I hope this makes sense!