it is a bit tricky and you will have to do a bit of trial-and-error here:
=> It is quite hard to get Qlikview to display something that is not available.
- That said, the next important questions to ask yourself would be:
=> What format is your base_data?
=> Do you have a field for that day and simply no value in it (blank field)
or is there no field available for that day?
=> How is your fact_table (for the chart) linked to the calendar?
=> Which fields are you using as dimension? Those from the fact_table itself or from the calendar
(the fact_table might not have a field for that day, but the master_calendar should, no?)
=> You might need a "dummy formula" (hard-coded as 0) just to force QlikView to display the chart_area when there
is no value to display.
ok the dimensions in the line chart are from my master calender. so that shouldnt be the issue right?? and my master calender are linked through the date field (_DATE) how can I create dummy values??
When i use a table object and I select a date wich has no profit it still schows a line in movement with only a value in the date field
Check enclosed file...
To make NULL to 0...
IF(ISNULL(Sales), 0, Sales) as Sales
But in your database there should not be any NULL values as the Dates themselves are not exists...!!!
Test.qvw 136.0 K