dates in dimension

[kamielrajaram]

Good day,

Please could you assist. I would like to display all dates for my month selection in a dimension irrespective if there is data or not.

Thank you in advance

Kamiel

[ToniKautto]

Please provide a sample QVW with your chart so that all the dimensions and expressions can be evaluated.

[perumal_41]

Hi,

Uncheck Suppress Zero Value and Suppress Missing in Persentation Tab.

[CELAMBARASAN]

Hi,

     Check Show all values option in the dimension tab for that dimension.

     Uncheck Suppress Zero Value and Suppress Missing in Persentation Tab.

Celambarasan

[kamielrajaram]

Thnaks, I have done this , but an example :

The date range I have chosen is from 01/02/2012 to 29/02/2012. There is only data from the the 13/02/2012. Ideally I want to show all dates within the date range. that means that from the 1st to the 12th the column would be null, but still needs to tbe shown.

Kamiel

[CELAMBARASAN]

Hi,

     Do you have that range dates in your calendar table?

Celambarasan

[#7]

Hi,

I think you will have to create a caldendar table in your script and assign 0 values to the each date to get the all dates apprear in your data irrespective of actual data.

Sandip.

[#8]

Hi,

I think you will have to create a caldendar table in your script and assign 0 values to the each date to get the all dates apprear in your data irrespective of actual data.

Sandip.