Want to display continuous date values as Zero if data is not available in Main fact table

[Srinivas]

Hi Team, 

I want to display the dates continuously if data is not available in final fact table, I have tried based on  master calendar but not shows the continuously dates values. 

I am expecting below output like that so on :

Please find the sample data file and qvws file.

Regards,

Munna

[sunny_talwar]

One way would be to uncheck 'Suppress Zero-Values' on the presentation tab of the chart properties.

[Srinivas]

Thanks for replay, 

This is the simple application we can unchecked suppress zero values in presentation level and see the all values.

In my real time app have very big data and based on fact table date filed i have created the master table and tried all possible types. But that application doesn't shows the null values where miss the data.

Please let me know, Any other way to solve the problem..

Regards,

Munna

[Srinivas]

Hi Sunny,

Initially we can see all the data but when I selected the any filter i can see only limited dates values only not continuous values.

Initially shows me like:

1. when I selected any filter:shows me below out put but I need continuously dates with null values(0).

Even I tried multiple ways but i can get the continuous dates with all values. 

Thanks,

Srinivas

[sunny_talwar · Accepted solution]

Change your expression to this

Sum(Sales)+Sum({1}0)